Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a derived column but the number there is in text format. I have tried different DAX formular to conver it to the right format(integer) but always get error e.g
Solved! Go to Solution.
@Anonymous
Actually I was expecting this response. Apparently you have more than just numbers in this column. In order to detect the cell(s) that have the problem use the following code then look for the blank cells:
IFERROR ( VALUE ( Sheet2[Size Value] ), BLANK ( ) )
Hi @tamerj1
Thank you!!! , that worked for me. I have tried using blank before but did not work but the IFERROR statement helped. Thank you so much.
Hi @Anonymous
Try VALUE function >>> VALUE ( Sheet2[Size Value] )
Thanks for the response. Unfortunately I still face the same issue.
@Anonymous
Actually I was expecting this response. Apparently you have more than just numbers in this column. In order to detect the cell(s) that have the problem use the following code then look for the blank cells:
IFERROR ( VALUE ( Sheet2[Size Value] ), BLANK ( ) )
User | Count |
---|---|
16 | |
15 | |
14 | |
12 | |
11 |
User | Count |
---|---|
19 | |
15 | |
14 | |
11 | |
9 |