Forum Discussion
Multiple Dates for funnel-ish!
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.
I think the query summary is missing something,
Please check the result after adding the last line from the table below.
Client ID Inboud date Order Date Amount Invoice Date
1212 01-12-17 15-12-17 100 31-12-17
The clients gets counted as 3 in December if you add the above line.
Hi,
Why not? The change is structure is happening at the backend.
Hi Ashish_Mathur;
The data structure change wouldn't be possible, as in the current excel suggestion,
Although it would be much easier to get that result and much less formula's.
Pardon my limited understanding,
1. Do you mean that the Data1 is automatically created using some formula ?
or
2. Create a New Data Source / Table with the suggested data structure ?
With changing the data structure and adding a new table,
I would require to link it to the current table that has over 60 Columns worth of Data and Growing.
This would ultimately affect the processing speed and load time for Maps on the BI +++ and never ming the refesh time.
Mind you the current data source is a .csv
This is why I had hit the wall on this issue and need a formula to grab those results without changing the structure.
I had been researching google for a couple of days now however this is not your typical {index/match how to video} .. haha
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.
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
Hi,
Thank you for your kind words. Glad to help.