Forum Discussion

AlAlawiAlawi's avatar
AlAlawiAlawi
Helper I
8 years ago
Solved

Multiple Dates for funnel-ish!

Hello Everyone;   I am frustrated with this and waiting for super geek to hit me on the head. The screen shot says it all, first part is te sample data, Then usually what most look at are if the ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi AlAlawiAlawi,

     

    Data1 has been auto generated by using Power Query.  So the end user will maintain data the way you uploaded it.  The internal process will create Data1 and get your desired result.  The end result is much simpler DAX Formulas as compared to my first solution.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi AlAlawiAlawi,

 

Data1 has been auto generated by using Power Query.  So the end user will maintain data the way you uploaded it.  The internal process will create Data1 and get your desired result.  The end result is much simpler DAX Formulas as compared to my first solution.

 

AlAlawiAlawi's avatar
AlAlawiAlawi
Helper I
8 years ago

Good Day Ashish_Mathur

 

First!

 

Thank You very much for the time spent on this topic and the effort included ...

You are a blessing for this forum / community and I can't express how your hint had broadend my view with unpivoting tables ...

 

This took me a while to go around and re-structure new measures to accomodate to pre-existing dashboards which was a much bigger pain. This re-structure of new tables columns measures truely allowed a more dynamic approach to how I could segment things which weren't possible due to my limited sight of the unpivot option.

 

You havent answered only my question but also took me to a new learning curve that will help me moving forward.

 

Thank You

Alawi

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Thank you for your kind words.  Glad to help.