topic Re: Power BI formula for subtracting previous month from currrnt month in DAX Commands and Tips

Power BI formula for subtracting previous month from currrnt month

BLittlejohn3 — Thu, 09 Nov 2023 01:41:35 GMT

I know this should not be this hard. All I want to do is show the difference in the current month and previous month. Can someone please help me with this dax calculation? It would be awesome if it were some current vs. prior so I didn't have to redo this for each month? Thanks in advance.

Re: Power BI formula for subtracting previous month from currrnt month

FreemanZ — Thu, 09 Nov 2023 02:09:53 GMT

there are many ways to do so, with functions like: EDATE, PREVIOUSMONTH, DATEADD....

but most importantly, check this:

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/m-p/1626726#M32906

Re: Power BI formula for subtracting previous month from currrnt month

BLittlejohn3 — Thu, 09 Nov 2023 03:08:26 GMT

I'm not trying to go down the rabbit hole for another four hours looking for what might work...Simple formula would work to solve this...