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