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
    George1973
    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
George1973's avatar
George1973
Icon for Helper V rankHelper V
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