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 

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.