Forum Discussion
Help Converting Tableau Date logic to PowerBI
Your calendar table only extends into the past. Time intelligence functions require a covering table, including the results of the calculation.
You are missing a Year-Quarter column
Your selections are a mix of comparisons ("versus") and scalar values ("YOY"). That is not something you can meaningfully show in a single visual.
Here's a general approach for the Switch statement, using measures as visual filters:
Super UserThe standard approach in Power BI is to use the Filter Pane, and to train your report users on how to use it.
If you don't like that, use a disconnected reference table and a giant SWITCH statement to cover all scenarios.
I am trying to use a giant switch statement. I know how to use the filter panes but I want more advanced filtering abilities.
- lbendlin
Please fix the sample data link. Asks for access.
- lbendlin
Your calendar table only extends into the past. Time intelligence functions require a covering table, including the results of the calculation.
You are missing a Year-Quarter column
Your selections are a mix of comparisons ("versus") and scalar values ("YOY"). That is not something you can meaningfully show in a single visual.
Here's a general approach for the Switch statement, using measures as visual filters: