Forum Discussion

amirzoyan's avatar
amirzoyan
Regular Visitor
4 years ago
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...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

amirzoyan's avatar
amirzoyan
Regular Visitor
4 years ago

thanks for that!

but just to confirm - the steps you listed, how and where do I accomplish this?