Forum Discussion
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,...
Hi,
I am not sure how your semantic model looks like, but I believe FIELD PARAMETER feature can help to solve your problem.
Please check the link down below from Microsoft Learn.
Use report readers to change visuals (preview) - Power BI | Microsoft Learn
Hi Jihwan_Kim,
The 3 columns previous_day, MTD, YTD the values are already set to either Y or N.
Im looking at creating the parameter in pagenated report.
I would like to pass Previous Day = Y or MTD = Y or YTD = Y to the query and return dates based on this.
Thanks
Griggers