Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Good Morning,
I am new to DAX and am struggling to find the formula for this. What I want to do it count anything in a coloumn that is greater than 00:00:05 seconds.
Attached is a picture of the collumn I need to calculate, sorry I cant show you more as this is sensitive data.
Any comments are welcome
Kind Regards,
Sam
@Anonymous , A new column
If(Table[col] >time(0,0,5),1,0)
@Anonymous
You can try the following formulas
Measure1 = CALCULATE(COUNT('SHEET1'[ID]),FILTER('SHEET1'[TIMEFIELD]>=TIME(0,0,5)))
Measure2 = CALCULATE(COUNT('SHEET1'[ID]),FILTER('SHEET1'[DATEFIELD]>=DATE(2020,10,12), 'SHEET1'[TIMEFIELD]>=TIME(0,0,5)))
The second measure is erroring giving me the following message:
Sorry for being a pain
Regards,
Sam
@Anonymous
You forgot a comma between DATE(2020,01,01) , (and before eCRSStat)
Sorry @Anonymous
Please replace comma with && (2 ampersand)
CALCULATE('TABLE'[COL],'TABLE'[COL]>=TIMEVALUE("00:00:05"))
some adjustments should be needed according to your model
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
29 | |
14 | |
11 | |
10 | |
9 |