Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
When I calculate a datediff in hours I haven't any problem:
@Anonymous
Strange that the HOUR works! Creating time related calculated columns is not allowed in direct query. You have to create measures only
how I calculate 'hh:mm' or decimal hours with only measurement and without column? I want a value for every row without a calculation like sum, average, ...
Hi @Anonymous
This might require further formatting
Countdown (minutes) =
VAR TimeDifference =
SUMX (
mysql_reports,
IF (
ISBLANK ( RELATED ( mysql_mail_log[created] ) ),
DATEDIFF ( mysql_reports[*NU], mysql_reports[first_report_expected], MINUTE )
)
)
RETURN
QUOTIENT ( TimeDifference, 60 ) & ":"
& MOD ( TimeDifference, 60 )
Would be great if you can provide sample file
I don't succeed 😞
Is it possible to mail you the file?
I hope you can give me the solution.
@Anonymous
I sent my email in a private message
@Anonymous
Even more simple is just to substract and select "Short Time" data type manually.
Countdown (minutes) =
SUMX (
mysql_reports,
IF (
ISBLANK ( RELATED ( mysql_mail_log[created] ) ),
mysql_reports[first_report_expected] - mysql_reports[*NU]
)
)
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
12 | |
10 | |
6 |