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 all,
Was wondering if anyone has ever come accross this challange. I've searched all over forums but couldn't find anything speficif on this.
I have a column in one of my tables that has mixed data types in it text and numbers but it's stored as a text type. I know it's not ideal especially if it's the way it's stored in the database - due to it being a history log which monitors changes within pipeline those being values, statuses, probabilities etc.
I've tried creting a filtered measure as per below:
Solved! Go to Solution.
i have done somthing like this before, not sure if this is the best way but it works well for me.
first i add a calculated colunm that will check the value in the [New Value] field and return the data type based on some checks.
Proud to be a Super User!
i have done somthing like this before, not sure if this is the best way but it works well for me.
first i add a calculated colunm that will check the value in the [New Value] field and return the data type based on some checks.
Proud to be a Super User!
Hi Tony!
This has actually worked a trick! I knew I couldn't be the only one stuck with the same problem. It's such an unideal situation being stuck with mixed datatypes.
This is really fabolous! Thank you so much for your help!
Kasia
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |