Forum Discussion

George1973's avatar
George1973
Icon for Helper V rankHelper V
4 years ago
Solved

Convert Calculations based on date inteligence into table

Hi DAX Gurus ๐Ÿ™‚ There is a very simple measure calculating "Product Sold Quantity": Sold Prod Qnty = CALCULATE (SUM(TS_OPERATIONS_DOP[KOL]), FILTER(TS_OPERATIONS,TS_OPERATIONS[OPER_TYPE_ID] == ...
  • George1973's avatar
    4 years ago

    Hi,
    I have soled the problem with the following approach:

    VAR CurrDate=SELECTEDVALUE(DateKey[MonthIndex])
    VAR MaxDate=MAX(DateKey[MonthIndex])
    
    VAR Fut_Dem=
    SWITCH(true(),
            MaxDate=CurrDate-1,Data_1,   
            MaxDate=CurrDate-2,Data_2,
            MaxDate=CurrDate-3,Data_3,
            MaxDate=CurrDate-4,Data_4,
            MaxDate=CurrDate-5,Data_5,
            MaxDate=CurrDate-6,Data_6,
            MaxDate=CurrDate-7,Data_7,
            MaxDate=CurrDate-8,Data_8,
            MaxDate=CurrDate-9,Data_9,
            MaxDate=CurrDate-10,Data_10,
            MaxDate=CurrDate-11,Data_11,
    Data_0)
    
           
    
    Return
    Fut_Dem