Measure for forecasting for a cumulative count

[MCacc]

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 solution]

Hi @MCacc ,

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 the table CALENDAR and FACT_TABLE 

3. Create a line chart(X-axis:CALENDAR[Data]   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

[Rupak_bi]

Hi @MCacc 
you already using a separate calender table and hope that have all the dates. unable to understand where you stucked. please share sample data and expected output for better understanding.