Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I want to create a report. I have dataset and by using DAX I change the dataset to the format I need.
Than it looks like that:
Name | Personal number | Date from | Date to | Department | Type |
Peter | 121412 | 12.08.2020 | 24.09.2020 | D1 | X |
George | 121516 | 24.12.2019 | 01.02.2020 | D2 | X |
George | 121516 | 01.03.2020 | 05.08.2020 | D1 | Y |
By using DAX I need to create this table:
Name | Personal number | Department | Type | Week | Year |
Peter | 121412 | D1 | X | 33 | 2020 |
Peter | 121412 | D1 | X | 34 | 2020 |
Peter | 121412 | D1 | X | 35 | 2020 |
Peter | 121412 | D1 | X | 36 | 2020 |
Peter | 121412 | D1 | X | 37 | 2020 |
.... |
It means that I want to have for each week between daterange (from-to) one row.
How can I do that?
Thank you,
George
Solved! Go to Solution.
@JiriS, I've done it for Dates in this file.
https://www.dropbox.com/s/bqbei7b8qbq5xez/leavebetweendates.pbix?dl=0
If you can week and year on your calendar. You should be able to group in the year of the week
@JiriS, I've done it for Dates in this file.
https://www.dropbox.com/s/bqbei7b8qbq5xez/leavebetweendates.pbix?dl=0
If you can week and year on your calendar. You should be able to group in the year of the week
Thank you for your solution.
George
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |