Forum Discussion
Helper IIConfusion regarding PREVIOUSMONTH
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.
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
2 Replies
- Greg_Deckler
Community Champion
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
JBI 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