Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
1) is there any dax function which would help me identify data type of a data in column?
Eg. CheckDataType( 'Data'[Date])
2) I would like to convert values in 2 columns in two tables to create relationship between 2 tables (I can use Dax only 🙂
I've already gave it a solid try with no success so any idea is welcome.
I would be thrilled to see sth like cast in SQL.
Solved! Go to Solution.
Hi @Nekkar ,
In that case this should work, create a new column:
Yes, I really do. I do not have access to options you show. I cannot change anything.
And I would like to use columns from the example to create a relationship so I need to have them as the same data type.
Hi @Nekkar ,
In that case this should work, create a new column:
unfortunately it doesn't work.
Hi @Nekkar ,
Do you really need this to work using DAX? Otherwise when you select a Column and go to Column tools you can see & edit the Data type here:
Jori
If I answered your question, please mark it as a solution to help other members find it more quickly.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 |