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

I'm trying to solve it with this solution, but I'm getting the error:

VAR CurrDate=SELECTEDVALUE(DateKey[Date])
VAR MaxDate=MAX(DateKey[Date])

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

       


Return
Fut_Dem