Forum Discussion

Palmtop's avatar
Palmtop
Icon for Helper I rankHelper I
3 years ago
Solved

How to "flatten" a variable into constant?

Hello All,      I have 2 curves that contains a low and high case sales scenario.  I would like to find the ratio between these 2 curves (Sales High / Sales Low) on the date of the latest mo...
Help Request
Palmtop's avatar
Palmtop
Icon for Helper I rankHelper I
3 years ago

Hello daXtreme,

 

Thanks for the advice.  I've edited my post with the formatted DAX measure and a link to a sample file.  Let me know if anyone has difficulties accessing it.  Otherwise, I hope this is a good starting spot to help solve the issue.  

  • Palmtop's avatar
    Palmtop
    Icon for Helper I rankHelper I
    3 years ago

    Hi daXtreme,

     

    Thank you, it worked like a charm.  I appreciate all the help and patience.  Also the clode cleanup is very welcomed 😉 .

     

    I read through the date table page from PowerBI -

    https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables

    but still don't fully understand why is it exactly that auto-generated hierarchies in my initial model caused the issues it did, and how getting rid of them by making a date table fixed the issues.   

     

    Thanks again!

     

    • daXtreme's avatar
      daXtreme
      Icon for Solution Sage rankSolution Sage
      3 years ago

      That's not exactly correct. It's not the auto-gen hierarchies that were the issue. It's the fields that were. You used the wrong fields from the wrong tables. As for the auto-gen hierarchies... JUST DON'T EVER USE THEM. Forget they exist. Always create your own Date tables. ALWAYS. Take this advice or suffer. Easy as that.