Forum Discussion
George1973
Helper V
4 years agoConvert 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] == ...
- 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
Helper V
4 years agoOne clarification: Whay I need it, ok.. let's see the following chart:
The Blue Line is the "Smoothed" data, of the previous months.. I used excel to have my seperated "Scenarios" on one table together with the original data.. and now I got it. But, I need it in Power BI - Automated. ๐