Measure for forecasting for a cumulative count

Question

Hello, I have a measure in which I calculate the cumulative count of a rows of my fact table.

For this measure, I have been asked to do a forecast for every day of one month. I say one month only because my user is interested in analyzing each month seperately.

There's no difference between workdays and non-working days

This is my cumulative count:

Measure =

CALCULATE(COUNTROWS(FACT_TABLE),

FILTER(

ALLSELECTED(FACT_TABLE),

FACT_TABLE[DIMENSION] = "XYZ" &&

FACT_TABLE[Data] <= MAX (CALENDAR[Data])

))

The only problem is: I don't have EVERY SINGLE day for my every month available in my fact table.

Any idea how I can write my dax?

Thank you very much for your help-

anonymous · Accepted Answer

Hi&nbsp;MCacc&nbsp;,
You can follow the steps below to get it:
1. Create a calendar table which includes every single day for the entire year
2. DO NOT create any relationship with&nbsp;the table&nbsp;CALENDAR and&nbsp;FACT_TABLE&nbsp;
3. Create a line chart(X-axis:CALENDAR[Data]&nbsp; &nbsp;Y-axis: [Measure]): you can refer the following link to get it
How to Create a Line Chart With Cumulative Values in Power BI - Monocroft
Apply forecasting

Best Regards

Forum Discussion

Measure for forecasting for a cumulative count

2 Replies

Related content

Cumulative Actual and Forecast

Cumulative Difference from Another measure

Cumulative Forecast

Cumulative inventory Forecast

Cumulative Measure