Average of future months with cumulative

DAX DAX Showcase
1

I am trying to calculate average of next future months with cumulative.

Please find enclosed the pbix file for further details.

I am very grateful if you could please resolve it.

Thank you.
cumulative example.pbix (117.6 KB)

2

CumulativeNextYear =
VAR CurrentRowDate = ‘DateTable’[Date]
RETURN
SUMX(
FILTER(
ALL(‘DateTable’),
‘DateTable’[Date] <= CurrentRowDate && MAX(‘DateTable’[Date]) = CurrentRowDate
),
[NextYearValues]
)
Use this syntax and make the necessary changes according to your values and hope this will help.

3

Thanks for responding Abbi.

How to calculate future months value?

That should be averages of last months.

After that I need cumulative with all months with correct total.

4

@Harsh please help me. Pbix file has attached for your reference.

5

Hi @khurram,
Did you search/ check any of the courses on EDNA Portal? Youtube? Have you used chatGPT or any other AI Tool and ask the question on the AI Tool?

Practice in the forum is not to call out anyone in the forum.

thanks
Keith

6

Hello Keith,
I had not idea about calling in the forum is restricted. sorry for that.

Yes I tried on Youtube , google and Edna portal to find out the answer but I couldn’t find it.

I will be very thankful if you could help me in this query.

Thanks & Regards,

7

Sorry i can’t help with that. Maybe try Chatgpt or another AI tool. Did you try the microsoft community too?

All of would do and try to dividing things in sections. Calculate the monthly future first and then add the cumulative portion.