Forum Discussion
AlAlawiAlawi
Helper I
Helper IMultiple 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.
AlAlawiAlawiHelper I
Helper IIdeally, For a KPI; All activities count.
So if a executive had been active and had recieved an Inbound for XYZ in January but an order in Jun, then both activies counts.
It just needs to be segmented as such.
I am using a Distinct Count anyway so the YTD Should Flush the Duplicates of Customers by ID.
Thanks for your reply
Ashish_Mathur
Super User
Super UserHi AlAlawiAlawi,
If you are doing a YTD count, then the number of customers for each of those months should be 2. Isn't that correct?