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 decimal numbers.
I want to create a Card Visual that shows the quotient between the sums of these columns (Invoiced hours/Registered hours). How can I do that?
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.
2 Replies
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!
