Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Making a single row with multiple new columns

Hi, I have an SQL extract that produces a table forecasting the dates for mainteance events but it produces a row for each event, with a single week-year that the activity would take place. I would l...
  • mussaenda's avatar
    2 years ago

    Hi Anonymous ,

     

    Yo can Pivot the Week by Type.

    Buuuuut. It is advisable to have more columns than to have more columns

     

    Why do you need to do this kind of step in M query?

    If you just want to show the data by week, you can use the matrix visual instead of doing it here