Forum Discussion
Solved
Calculating Dates across Rows
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 day...
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_GaoIf 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
Please upvote my answer if it helped resolve your issue 🙂 Prateek Raina