Forum Discussion
Solved
PreviousMonth not returning any data
Hi. I'm trying to setup a simple table using the PreviousMonth function. The two measures are setup as follows: Risk Score Calc = average(Defender[Risk Score - %Total]) Risk Score ...
Power BI is built so that it best functions when models are in a star schema. Time intelligence functions require this, specifically a date dimension table. You need to create a date dimension table, establish a relationship to your fact table, and adjust your DAX measure to utilize the date table.
Thank you very much - that solved the issue.