Forum Discussion

Crawfom's avatar
Crawfom
Regular Visitor
2 years ago
Solved

Creating a calculated column in Matrix

I am a newbie to PowerBi and am getting stuck. I have a Matrix built from source data and want to add a 3rd column which is <<Current period>> divided by <<Last Year>>. When I build a column in the...
Need Help
  • mickey64's avatar
    mickey64
    2 years ago

    For your reference.

    How about a measure below?

     

    Measure = DIVIDE(SUM([Current Period]),SUM([Last Year]))

     

mickey64's avatar
mickey64
Super User
2 years ago

For your reference.

How about a measure below?

 

Measure = DIVIDE(SUM([Current Period]),SUM([Last Year]))

 

Crawfom's avatar
Crawfom
Regular Visitor
2 years ago

mickey64 - thank you.

I added a new "measure" into the data table using your formula then a new column into the Matrix - which gave me the right answer!  

Everyday is a learning day and you have helped me on this one - thank you!