Forum Discussion

diogoricciardi's avatar
diogoricciardi
Frequent Visitor
6 years ago
Solved

Add multiple columns using List.A

Hi all,   I have a table with daily sales information, where product categories are in rows and days of the month are in columns. My goal is to get each category's percentege of sales by day of th...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi diogoricciardi ,

    this sounds like a calculation that should better be performed dynamically with DAX.

    But if you really need to do it in the query editor in M, you should consider unpivoting the days columns (check the columns that should be kept and select: Unpivot other columns). Then you have just 2 columns to divide against each other.

     

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
6 years ago

Hi diogoricciardi ,

this sounds like a calculation that should better be performed dynamically with DAX.

But if you really need to do it in the query editor in M, you should consider unpivoting the days columns (check the columns that should be kept and select: Unpivot other columns). Then you have just 2 columns to divide against each other.

 

diogoricciardi's avatar
diogoricciardi
Frequent Visitor
6 years ago

Hi Imke,

 

That actually helped a lot. I can't believe I didn't see it hehe.

One of the last steps in my query was pivoting the table so the days would be in columns. So what I did was to calculate the percentages before pivoting it and it worked beautifully.

 

Thanks a lot, I appreciate it.