Forum Discussion

JR_Lee's avatar
JR_Lee
Frequent Visitor
4 years ago
Solved

Power Query transformation help

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...
Need Help
  • ImkeF's avatar
    ImkeF
    4 years ago

    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.

     

  • JR_Lee's avatar
    JR_Lee
    Frequent Visitor
    4 years ago

    amitchandakafter unpivoting all product columns how can i deal with the following:

     

    • amitchandak's avatar
      amitchandak
      Super User
      4 years ago

      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