Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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]
)
)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
11 | |
10 | |
10 | |
9 |
User | Count |
---|---|
18 | |
13 | |
12 | |
11 | |
8 |