Forum Discussion

kovacikm78's avatar
kovacikm78
Frequent Visitor
3 years ago
Solved

Calculation based on Max Date in Date Slicer while ignoring Min Date

Hello, could you please help me with this measure, where I want calcutate sales for last 90 days while keeping max date from the filter while ignoring min. date of the slicer. The solution should...
Need Help
ahmadibrahimbus's avatar
ahmadibrahimbus
Icon for Resolver III rankResolver III
3 years ago

Dear kovacikm78 ,

if I understand you correctly please use the below meausre:

Revenue PY =
CALCULATE(
SUM(Sales[Sales Amount]),
DATESINPERIOD(
'Date'[Date],
MAX('Date'[Date]),
-3,
MONTH
)
)

please refer to the DATESINPERIOD function in the below link:

DATESINPERIOD function (DAX) - DAX | Microsoft Learn

please markup this as an accepted solution if it works.

Best Regards,

  • kovacikm78's avatar
    kovacikm78
    Frequent Visitor
    3 years ago

    Hello,
    thank you very much for you help. The calculeation works fine ony if I dont use timeline. Once I add months in a table or chart, the result is computed only for specific month and not for the whole period (3 months back).
    It should work even for days. So if I have in table specific day, it should return sum of  sales for previous three months. Now it returs only one day. Or one month, if I choose months view...
    Is there a way it can be calculated that way?