Forum Discussion

o_belov's avatar
o_belov
Advocate II
2 years ago

Anonymous , try to use this logic

Sales_YD =

 

VAR MaxDate = MAX (ZIBP_PO_MGRTN[DELIVERY_DATE])
VAR MaxYear = YEAR(MaxDate )
RETURN
 
        CALCULATE(
            [sum_of_MG01],
            FILTER (
            ALL( ZIBP_PO_MGRTN),
            ZIBP_PO_MGRTN[DELIVERY_DATE] <= MaxDate
            && YEAR( ZIBP_PO_MGRTN[DELIVERY_DATE]) = MaxYear
           
                )
         )
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi o_belov ,

    Thank you for your response. 

    I tried the solution though its working but i am getting the result of whole column.

    See it's giving me cummulative total of whole column.

     

    Thanks,

    Ashishh