Forum Discussion

Merleau's avatar
Merleau
Helper II
6 years ago
Solved

Repeat columns based on values from another table

Hello, I have the following tables: TableA and TableB   TableA Id R1AM R2AM R2PM R3PM R4PM CountAM CountPM id1 1 0 0 0 1 1 1 id2 0 0 1 1 0 1 2 id3 1 1 1 1 0 ...
Need Help
Tips and Tricks
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Merleau 

Please check M queries in My pbix.

If you have any problem or need detailed steps, feel free to let me know.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Merleau's avatar
    Merleau
    Helper II
    6 years ago

    This is brilliant!

    Thank you so much.

    However, I had to pivot it back to compute the different total. I finally insert it as a table in my report. 

    This way, I have the freedom to arrange the columns in a particular order. As a matrix, I didn't know how to do it.

    Again, I appreciate the help.

    Thank you.