Hello,
I need help, I have a column that contains numbers and text, it is formatted as text, I need to check in dax if each value of the column is a number or a text.
I tried creating a calculated column but when it transforms it freezes because it gives an error on the type.
do you know a function that does this?
Solved! Go to Solution.
Hello, if you do not want to do this in PQ, I would create a calculated column as follows:
For Measure :
Hello, if you do not want to do this in PQ, I would create a calculated column as follows:
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
User | Count |
---|---|
127 | |
65 | |
36 | |
27 | |
23 |
User | Count |
---|---|
137 | |
79 | |
46 | |
37 | |
22 |