Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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]
)
)
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!