Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Dealing with somewhat of an odd problem. The example below, the data gets pulled automatically and the dates for a single report show up in different rows.
I know how to calculate # of days when the dates are in the same row, but not clear how to do it across rows. Any suggestions?
Including an image below - trying to figure out how to calculate # of days between the two circled dates.
Solved! Go to Solution.
Hi @amirzoyan,
I created a simple for test.
Please try.
Transform data.
Select all needed columns.
Unpivot Columns.
Select [Attribute] columns.
Pivot Column.
Close and Apply.
Attach the PBIX file for reference. Hope it helps.
Best Regards,
Community Support Team_Gao
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi @amirzoyan,
I created a simple for test.
Please try.
Transform data.
Select all needed columns.
Unpivot Columns.
Select [Attribute] columns.
Pivot Column.
Close and Apply.
Attach the PBIX file for reference. Hope it helps.
Best Regards,
Community Support Team_Gao
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
thanks for that!
but just to confirm - the steps you listed, how and where do I accomplish this?
This documentation is pretty good:
https://docs.microsoft.com/en-us/power-query/unpivot-column
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |