Forum Discussion
Griggers
1 year agoFrequent Visitor
DAX Parameter on multile columns
Hi, I have a date table that has a date, previous_day, MTD, YTD etc columns. For previous_day, MTD, YTD the values are either Y or N. Is it possible to have a parameter based on previous_day, MTD,...
danextian
Super User
1 year agoHi Griggers
Do those columns already have the expected to-date values? If so, you can use field parameters to switch between columns. https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
The Y/N column can be used in a slicer. Here's a demo of what field parameters can do.