Forum Discussion
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 ...
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.
You need a calendar table. https://exceleratorbi.com.au/power-pivot-calendar-tables/
Then you need 2 relationships, one for each of your date columns. https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/
Thank you for the response; Ill check this solution and reply back today if possible. Appreciate your reply dear.