Forum Discussion
assistance with DAX code please
hi team, im fairly new to power BI and am helping my colleague with some reporting. We are using a report created by someone else who has since left the organisation. The report displays some avera...
This is the Power Query forum. You may find better luck in the Desktop forum. But since you're here:
Can you convert the time interval to a base of seconds or minutes, (i.e.: some common integer value) then calculate a simple AVERAGE DAX Measure from that and compare the two? For example, if the existing report shows a single Manager's Average Time as 00:01:49 (DD:HH:MM ?) and your simple DAX Average is 109 minutes, then you know it is right.