Forum Discussion
Solved
Aggregating over data sets
Hello, I'm very new to PowerBI (come from a QlikView background) and attempting to calculate the 'absence' of data. We have a set of records for someones timesheet, and I want to work out the amo...
Just create a measure along the lines of:
Measure = 7.5 - SUM('Table'[Hours])Then just put that into a table visualization along with the other columns that you want to summarize by.
Just create a measure along the lines of:
Measure = 7.5 - SUM('Table'[Hours])Then just put that into a table visualization along with the other columns that you want to summarize by.
That was easy! Thanks for the help!
