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 

You can try the following measure

 

Quantity Prior Period =
CALCULATE (
    SUM ( factTable[Quantity] ),
    DATE ( 2022, 8, 2 ) >= factTable[EffectiveDate],
    DATE ( 2022, 8, 2 ) <= factTable[ExpiredDate],
    DATEADD ( DimCalendar[Date], -1, YEAR )
)

 

If it cannot work,  can you provide some more sample data or related sample file?

 

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.