Forum Discussion
Dimension column based on page date slicer value - possible?
- 1 year ago
Anonymous You can create a measure that calculates the preceding month based on the selected [First of Month] value from the slicer.
Create a measure for the selected [First of Month]:
SelectedFirstOfMonth = SELECTEDVALUE('Calendar'[First of Month])
Create a measure for the preceding [First of Month]:
PrecedingFirstOfMonth = EOMONTH([SelectedFirstOfMonth], -1) + 1
Create a measure to filter the data for the preceding month:
DAX
PrecedingMonthData =
CALCULATE(
SUM('YourTable'[YourDataColumn]),
'Calendar'[First of Month] = [PrecedingFirstOfMonth]
)Use the SelectedFirstOfMonth measure to filter the data for the selected month:
DAX
SelectedMonthData =
CALCULATE(
SUM('YourTable'[YourDataColumn]),
'Calendar'[First of Month] = [SelectedFirstOfMonth]
)For the first graph, use the SelectedMonthData measure.
For the second graph, use the PrecedingMonthData measure.
Hi Anonymous,
May i know has your issue been resolved? If the response provided by the community member bhanu_gautam, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.
Thank you for your understanding!
Hi
Appreciate you want things wrapped up quickly, will try my best.