Forum Discussion

webbj's avatar
webbj
Icon for Helper I rankHelper I
4 years ago
Solved

Measures Calculation?

I'm wondering if anyone can help me with a calculation. The issue is that the data is all stored in a single column, my manager would like the the data displayed by product without breaking it down b...
Need Help
Tutorial Requests
  • Syk's avatar
    Syk
    4 years ago

    You can edit the data in the power query editor


    Then just rename your columns

     

webbj's avatar
webbj
Icon for Helper I rankHelper I
4 years ago

I thought that might be the answer - sheet duplicating the column is there a way within powerbi to do a replace - where column cell = product 1 replace with X.

 

The data is being pulled in by an API so I can't format the source - only the data I get in powerbi 

 

 

  • Syk's avatar
    Syk
    Icon for Resident Rockstar rankResident Rockstar
    4 years ago

    You can edit the data in the power query editor


    Then just rename your columns

     

    • webbj's avatar
      webbj
      Icon for Helper I rankHelper I
      4 years ago

      Thankyou! This resolved my main issue, couple of extra tweeks and it was working 🙂