Confusion regarding PREVIOUSMONTH

[JB]

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. 

[Greg_Deckler · Accepted solution]

@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-TIT...

[JB]

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

1. Create a date table with all possible dates for which you might want to find the next day
2. Use said date table as the parameter for the NEXTDAY function
3. Ensure that a relationship exists between your fact table and your date table
4. 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