Forum Discussion

Caldowd98's avatar
Caldowd98
Helper I
4 years ago
Solved

DATESINPERIOD Function

Hi Community   Im using the Datesinperiod funtion will the below DAX formula, however it doesnt seem to work with the filter in.   Any ideas ?   Many Thanks !   LTM Brand 1 = CALCULATE(SUM('...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  Caldowd98 ,

    Here are the steps you can follow：

    1. Create measure.

    Measure =
CALCULATE(SUM('Sheet1'[Quantity]),FILTER(ALLSELECTED('Sheet1'),'Sheet1'[Type]="Brand 1"&&'Sheet1'[Date]>=DATE(YEAR(MAX('Sheet1'[Date]))-1,MONTH(MAX('Sheet1'[Date])),DAY(MAX('Sheet1'[Date])))&&'Sheet1'[Date]<=MAX('Sheet1'[Date])))

    2. Result:

    Will vary with the filter: say, filter out October 2021, and the result will vary

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi Caldowd98 ,

 

Kindly share some sample data in text format with desired output, it will help us to answer more specifically. 🙂

NOTE:- Time intelligence functions work well when you have date table in your model. Try to add calender table into the model then hopefully you will get desired output.

 

Thanks,

Samarth