Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
How do I transform a spreadsheet that contains multi-monthly time periods so that I can evaluate them with a date hierarchy after months or days? For example, a table contains a From Date column and a To Date column. How can I discretize this data to make a daily analysis? The table I have looks like this:
Thanks.
Holger
Solved! Go to Solution.
Sie mussen expand each row into as many (consecutive) Tage as there are in the VON-BIS period and allocate all Ihre Zahlen accordingly. Then it's leicht: you just join your Daten table an die Tagen and you'll be able to author einfach(es?) DAX.
Best
D.
Thanks, but sorry, I can't follow you. How to expand each row in the table (which function can I use)? Thanks.
Holger
Yes, ok. Which function of PQ would you use for this task?
Perfect, thank you.
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |