Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
68 | |
48 | |
45 | |
18 | |
15 |