Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm struggling to transform the following data:
so it looks something like the below for each salesperson and each month:
this is where i've got to but i cant seem to isolate the month names:
Solved! Go to Solution.
Hi @JR_Lee ,
1) add a column with the following syntax: "if [Column2] = "Coke[PG 29]" then [Column1] else null
2) Check that new column and fill down values. This will returne a column with the repective months in rows.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @JR_Lee ,
you must do that before the unpivoting.
Either before or after the Promoted Headers step:
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @JR_Lee ,
1) add a column with the following syntax: "if [Column2] = "Coke[PG 29]" then [Column1] else null
2) Check that new column and fill down values. This will returne a column with the repective months in rows.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @ImkeF
Not sure if I have misundestood but when I add the column I get the following (which inclueds the salesperson name)
@JR_Lee , Unpivot all product columns in power bi
https://radacad.com/pivot-and-unpivot-with-power-bi
@JR_Lee , I think this requires a little bit of clean-up outside power bi, having a month on a column.
But check with M expert.
@ImkeF , any suggestion for this
User | Count |
---|---|
85 | |
76 | |
72 | |
69 | |
56 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |