powerbidaxpowerbi-desktop

Power BI, I need to calculate sold product between two date

I'm new in Power BI.

I need to calculate total sold product between two dates, e.g. from 5 Feb 2021 to 5 apr 2021, I can't find any solution.

Solution

  • Assume you have sales table with two column Date and Amount. Now you can create your measure as below-

    total_sold = 
CALCULATE(
    SUM(sales[amount]),
    DATESBETWEEN(
        sales[date],
        start_date,
        end_date
    )
)