Forum Discussion

rcarhart2's avatar
rcarhart2
Frequent Visitor
1 year ago
Solved

Help Converting Tableau Date logic to PowerBI

I am trying to convert my date logic in tableau to powerBI: I have tried using AI but it does not seem to understand the end goal. Lets see if humans can still beat the AI. I have attached a workbook...
"Dates"
"DAX"
  • lbendlin's avatar
    lbendlin
    1 year ago

    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:

     

     

     

     

lbendlin's avatar
lbendlin
Super User
1 year ago

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:

 

 

 

 

rcarhart2's avatar
rcarhart2
Frequent Visitor
1 year ago

lbendlin thanks for taking time out of your day to look at this. This gives me a different way to look at the problem. appreciate it.