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...
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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Aakash_Ladi 

        The userelationship() function is used between inactive relationship, the relationship between your tables is active, so it is not neccessary to use the function.

         

        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.