Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello BI World,
I've been using power BI for a bout 2 months now and love it! I'm hoping someone with M or DAX super powers can help me with a snag I ran into.
I have a column representing the difference between two times in format days:hours:minutes:seconds (See Screenshot).
I would like to have a column in a different table to reflect the average difference based on the value of another column.
Thanks in advance!!!
Eric
P.S. - In query editor the column looks like it does in the screen shot. In data view it's formatted 00:00:00 AM/PM???
Hi @Eric_JL,
Do you want to calculate average value of the TimeDifference column? If that is the case, duplicate your current query in Query editor, then choose the TimeDifference column, select “Duration->Statistics->Average” under Transform ribbon, then you will get average value as shown in the second screenshot, and you can put the value in a column by clicking “To Table”.
Thanks,
Lydia Zhang
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |