Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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 |
---|---|
17 | |
16 | |
14 | |
13 | |
12 |
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |