topic Re: Need help with running total in DAX Commands and Tips

Need help with running total

Anonymous — Mon, 27 Dec 2021 18:29:56 GMT

I am atemting to get a running total from the start of wnd of 2019 to the current date. Included is a picture of my dax code that is not currently working. Thanks!

Re: Need help with running total

AlexisOlson — Mon, 27 Dec 2021 19:01:49 GMT

Does it help at all if you replace the ISONORAFTER line with the following?

'Matt-DataForBI'[Date Closed] <= MAX ( 'Matt-DataForBI'[Date Closed] )

Re: Need help with running total

Anonymous — Mon, 27 Dec 2021 19:19:15 GMT

I tried that an unfortentetly it doesnt.

Re: Need help with running total

AlexisOlson — Mon, 27 Dec 2021 19:23:01 GMT

Hmm. What if you replace ALLSELECTED ( 'Matt-DataForBI'[Date Closed] ) with ALLSELECTED ( 'Matt-DataForBI' )?

Re: Need help with running total

Anonymous — Mon, 27 Dec 2021 20:53:07 GMT

I was able to fix it by making a my own date table and using this code:

Total Revenue running total in Quarter =

CALCULATE(

SUM('Matt-DataForBI'[Total Revenue]),

FILTER(

ALLSELECTED('Date'[Quarter]),

ISONORAFTER('Date'[Quarter], MAX('Date'[Quarter]), DESC)

)

Re: Need help with running total

AlexisOlson — Mon, 27 Dec 2021 23:55:56 GMT

Great! Having a date dimension table is almost always a good idea.

Re: Need help with running total

VahidDM — Tue, 28 Dec 2021 02:10:39 GMT

Hi Anonymous

You need to add a Date table [Calendar Table] to your report.
To work with Data Analysis Expressions (DAX) time intelligence functions, there's a prerequisite model requirement: You must have at least one date table in your model.

Check this link:

https://www.vahiddm.com/post/creating-calendar-table-with-3-steps

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/