topic Re: Confusion regarding PREVIOUSMONTH in DAX Commands and Tips

Confusion regarding PREVIOUSMONTH

JB — Tue, 08 Feb 2022 10:25:48 GMT

The official Microsoft website provides the following as an example for the correct use of PREVIOUSMONTH

= CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), PREVIOUSMONTH('DateTime'[DateKey]))

The expression below does not work for me, despite seemingly following the exact same structure and logic as the above example. It only returns '(Blank)', despite the Sort Score column containing data. Why is that?

= CALCULATE(AVERAGE(AuditTable[Sort Score]), PREVIOUSMONTH('Date Table'[Date]))

Thanks for your help.

Re: Confusion regarding PREVIOUSMONTH

Greg_Deckler — Tue, 08 Feb 2022 10:26:37 GMT

JB You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

Re: Confusion regarding PREVIOUSMONTH

JB — Tue, 08 Feb 2022 10:44:04 GMT

I went through one of your linked posts and found the following instructions:

Create a date table with all possible dates for which you might want to find the next day
Use said date table as the parameter for the NEXTDAY function
Ensure that a relationship exists between your fact table and your date table
Ensure that the cardinality of the relationship is such that it is Single from your fact table to your date table

I had already done steps 1-3 but had not ensured that the relationship between the two tables was Single. It is now and seems to work.

Thanks