topic Re: Calculate with PreviousMonth formula not working in DAX Commands and Tips

Calculate with PreviousMonth formula not working

samk9009 — Fri, 10 May 2019 13:56:39 GMT

Good afternoon,

I am trying to conduct a previousmonth formula with calculate. It seems to work when I reference a column from a table, however, when I reference a calculated measure that I have created in Power BI, I receive blanks in the output. Please see below:

The DAX code I used to obtain Prior Month Actual is:

Prior Month IFIS Actual YTD = CALCULATE('(f) IFIS Actuals'[IFIS Actual YTD], PREVIOUSMONTH('(d) Date'[Date]))

Any help would be greatly appreciated. Thank you!

- Sam

Re: Calculate with PreviousMonth formula not working

parry2k — Fri, 10 May 2019 05:05:28 GMT

samk9009

read this post to get your answer quickly

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Re: Calculate with PreviousMonth formula not working

samk9009 — Fri, 10 May 2019 13:58:23 GMT

Thank you for the feedback! I have made some minor edits to make the language easier to understand. Unfortunately, I cannot provide a spreadsheet or dashboard.

parry2k wrote:
samk9009

read this post to get your answer quickly

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490