Forum Discussion
Last Date for Distinct User and Item Modified
Hello Anonymous
My first thought is to split the items into 3 tables, tag them with their type and stack them.
Then you just use the stacked table and a couple measures.
I have attached my sample file for you to look at.
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
Hi,
Please find attached.
Super UserHello Anonymous
My first thought is to split the items into 3 tables, tag them with their type and stack them.
Then you just use the stacked table and a couple measures.
I have attached my sample file for you to look at.
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
jdbuchanan71 Thank you for the instructions and sharing the .pbix file, this worked perfectly. I have a questions regarding creating the 5 queries to make this- I will probably have over 10,000 rows - will this slow performance/load time/refresh time by a lot?
- jdbuchanan71
No, that should be no problem. Also, of the 5 queries (1 original, 3 splits, 1 stack) you only have to load the last one to your data model. In the query editor you can right click on a query and turn off 'Load to model'.