Hello,
I am currently trying to achieve a visual showcasing a line chart - one line chart with actual data and one line chart with predicted data given a KPI status (steady 6% decrease of data given a baseline in July 2022).
I have live data feeding daily and the predictive data has to be up until June 2023.
The current steps I have taken are as per below:
1. Created a calendar table, using the below DAX:
Calendar = CALENDAR(DATE(2022,7,1),DATE(2023,6,30))
2. Linked my data from my actual data table into the calendar table using the below DAX:
Total Current Data = COUNTROWS(FILTER(Table1, Table1[Date]='Calendar'[Date]))
3. Need to have the predicted numbers - July is the baseline and has to transfer over, the rest of the data is the earlier month given a 6% decrease - I started the formula below, but it is not the correct one:
Total predicted data =
IF('Calendar'[Date] = "July",
COUNTROWS(FILTER(Table1, Table1[Date]='Calendar'[Date])),
CALCULATE(COUNTROWS(FILTER(Table1,Table1[Date] = EARLIER(Date) *0.06))))
Could someone please assist with step number 3, thank you.
