Forum Discussion
Helper IIConfusion regarding PREVIOUSMONTH
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
Community ChampionJB 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
Helper III 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