Forum Discussion

Aakash_Ladi's avatar
Aakash_Ladi
Regular Visitor
3 years ago

MAX function not working as expected

Hi, Let me give a background to the problem I am facing: I have a fact table which is a snapshot table (it basically stores multiple modifications of same OrderID). For Modification date, we have...
Aakash_Ladi's avatar
Aakash_Ladi
Regular Visitor
3 years ago

Hi Anonymous,


Even DATEADD is not working. Please see the attached link for pbix file for your refrence(FYI I am not able to attach the file here, please see if you can access it from here or let me know if you can guide me how to add attachment).

https://shorturl.at/zJW18

 

Regards,

Aakash Ladi

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Aakash_Ladi 

The link cannot open, you can upload the file to onedrive, then share it.

 

Best Regards!

Yolo Zhu

 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Aakash_Ladi 

      It is not available.

       

      Best Regards!

      Yolo Zhu

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Aakash_Ladi 

      I change your  fulldate column first

      Order Date full = DATE(LEFT([OrderDate],4),MID([OrderDate],5,2),RIGHT([OrderDate],2))

      Then change the relationship

       

      Then change the PP measure

      Qty (PP) = var a= EOMONTH([PointDate],-13)+DAY([PointDate])
return
CALCULATE(SUM(factResSummary[Qty]), a>= factResSummary[EffectiveDate],a <= factResSummary[ExpiredDate],DATEADD(DimCalendar[FullDate],-1,YEAR))

      Output

       

      Best Regards!

      Yolo Zhu

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

      • Aakash_Ladi's avatar
        Aakash_Ladi
        Regular Visitor
        3 years ago

        Hi Anonymous ,

         

        Thanks for replying. I believe this will work. Could you please explain what was wrong with the earlier approach?

         

        Regards,

        Aakash Ladi