Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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]
)
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
24 | |
17 | |
12 | |
12 | |
10 |
User | Count |
---|---|
32 | |
25 | |
16 | |
14 | |
13 |