Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 ( ) )
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |