Forum Discussion
ldwf
Helper V
6 months agoShowing %Change from Prior Month in a visual when the visual is filtered to show only current month
I have a simple table visual that shows product attributes and a score. The table is filtered to only show information for the current month, but I need to display a %Change between Current and Prio...
- 6 months ago
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
Ashish_Mathur
Super User
6 months agoHi,
Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.