Forum Discussion

Simon_29's avatar
Simon_29
Helper II
2 years ago

Transposing columns

Hello, I need to create something similar to the screenshot below. I have TABLE 1 as a SharePoint list. I need to move the columns with First_Value into rows, because I need to continue working w...
Need Help
Show and Tell
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

You are performing the correct step i.e. "Unpivoting Other Columns".  The values are bound to repeat.  You will have to customise the DAX formulas to get your desired calculations workinng.

  • Simon_29's avatar
    Simon_29
    Helper II
    2 years ago

    Hi, thanks for advice.
    Since I'm weaker in DAX, could you try to draw for me how this metric could look like? Thank you 🙂 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      Hi,

      Share data in a format that can be pasted in an MS Excel file and show the expected result very clearly.