Forum Discussion
Helper VShowing %Change from Prior Month in a visual when the visual is filtered to show only current month
ldwf yes you need to define what prior month is, it is actual based on the calendar or indicator, if it is by calendar month, as a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on the table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist
Super Userldwf try this measure, drop this measure in the visual to check the value it returns, then later you can remove it from the visual
Prior Month Value=
VAR a=Calculate(
TABLE1(Score)
ALL ( Table1 ),
TABLE1(Prior_Reporting_Period_Ind="Y"
)
RETURN a
ldwfActually, the Prior_Reporting_Period_Ind should not be used. I defined it using the actual prior month whether there was a score or not, but many products may not have a value for the actual prior month, i.e, the prior month may be three months ago. Hence, I should probably define this not using indicators