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.
Hi guys,
Can you please help me with column cleaning. It has two data types ( int and text) and some blanks. I just want to keep them integers. Can you please help me writing Dax Querry.
Many Thanks, C
Column A |
12 |
10 |
20 |
A |
B |
C |
50 |
Solved! Go to Solution.
@Anonymous you can write a measure like this
Measure =
CALCULATE (
MAX ( 'Table 1'[Column A] ),
FILTER (
'Table 1',
IFERROR ( CONVERT ( 'Table 1'[Column A], INTEGER ), -999 )
= IFERROR ( 'Table 1'[Column A] * 1, 0 )
)
)
@Anonymous you can write a measure like this
Measure =
CALCULATE (
MAX ( 'Table 1'[Column A] ),
FILTER (
'Table 1',
IFERROR ( CONVERT ( 'Table 1'[Column A], INTEGER ), -999 )
= IFERROR ( 'Table 1'[Column A] * 1, 0 )
)
)
@Anonymous did you have a chance to look into the solution I provided?
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |