Forum Discussion

Nekkar's avatar
Nekkar
New Member
4 years ago
Solved

Dax data type identyfication, data type format change

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 tabl...
Need Help
  • jppv20's avatar
    jppv20
    4 years ago

    Hi Nekkar ,

     

    In that case this should work, create a new column:

    NewDate = DATE(RIGHT(Sales[SDate],4),MID(Sales[SDate],4,2),LEFT(Sales[SDate],2))
     
    Jori
     
    If I answered your question, please mark it as a solution to help other members find it more quickly.

Nekkar's avatar
Nekkar
New Member
4 years ago

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.

jppv20's avatar
jppv20
Solution Sage
4 years ago

Hi Nekkar ,

 

In that case this should work, create a new column:

NewDate = DATE(RIGHT(Sales[SDate],4),MID(Sales[SDate],4,2),LEFT(Sales[SDate],2))
 
Jori
 
If I answered your question, please mark it as a solution to help other members find it more quickly.

  • Nekkar's avatar
    Nekkar
    New Member
    4 years ago

    unfortunately it doesn't work.