Forum Discussion

Merleau's avatar
Merleau
Icon for Helper II rankHelper 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
Icon for Community Support rankCommunity 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
Icon for Helper II rankHelper 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.