Hello I am facing an issue on how to get a measure.
I have a table called tasks.
Each task row has a cell called Details which is fulfilled like this
************************************ 13-Aug-20 1:27 AM @ Person1: ************************************
lorem
************************************ 12-Aug-20 4:44 PM @ Person2 ************************************
ipsum
************************************ 12-Aug-20 6:00 AM @ Person3 ************************************
lorem
************************************ 10-Aug-20 13:27 AM @ Person2 ************************************
ipsum
And I will need to count the times that a Person has written for the last: 7 and 30 days for the whole table.
So I can produce a table like this:
Last 7 days | Last 30 days | |
Person 1 | 1 | 3 |
Person 2 | 4 | 8 |
Person 3 | 3 | 6 |
Splitting by delimiter is not a way as far as n columns may appear so I have no idea on how to filter.
I am thinking and I have no clue on how to do it. Any advice will be fantastic
Thanks in advance
Solved! Go to Solution.
I fixed it.
What I did is splitting by rows on the query by the **** array.
Then with manipulation I get all the times at one column and set the column type as data.
Remove all the errors
From here is pretty straight forward.
I fixed it.
What I did is splitting by rows on the query by the **** array.
Then with manipulation I get all the times at one column and set the column type as data.
Remove all the errors
From here is pretty straight forward.
Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
466 | |
180 | |
118 | |
61 | |
52 |
User | Count |
---|---|
445 | |
163 | |
129 | |
76 | |
73 |