Forum Discussion
Solved
Calculating quotient between columns
I'm really new to Power BI, trying to wrap my head around how I'm supposed to go about stuff. I have a table with two calculated columns: Registered hours and Invoiced hours, both containing dec...
moiran - In your data model (table looking icon on the left), click "New Measure". Then, use the following formula:
Measure = SUM([Invoiced hours]) / SUM([Registered hours])
Then, put that measure in your card visual.
moiran - In your data model (table looking icon on the left), click "New Measure". Then, use the following formula:
Measure = SUM([Invoiced hours]) / SUM([Registered hours])
Then, put that measure in your card visual.
It's so simple once someone explains it to you... Thank you!
