Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Dax time intelligence functions not working

Reading from Sage I have created in my transactions table a calculated column which contcatonates the month and last two digits of the year to make a code.   I then link them to a calnder table whi...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

    Please help to post sample data and your expected result. If you want to use DATEVALUE function and CONCATENATE function in Power BI Desktop, you can review the following example.

    Right click you table and choose “New column”, then you can write the following formula to return date values.

    Column = DATEVALUE(CONCATENATE(CONCATENATE(CONCATENATE(Table1[Month],"/"),CONCATENATE(Table1[Day],"/")),Table1[Year]))

    Column1 = DATEVALUE(CONCATENATE(CONCATENATE(CONCATENATE(Table1[Month],"/"),CONCATENATE("01","/")),Table1[Year]))


    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

Please help to post sample data and your expected result. If you want to use DATEVALUE function and CONCATENATE function in Power BI Desktop, you can review the following example.

Right click you table and choose “New column”, then you can write the following formula to return date values.

Column = DATEVALUE(CONCATENATE(CONCATENATE(CONCATENATE(Table1[Month],"/"),CONCATENATE(Table1[Day],"/")),Table1[Year]))

Column1 = DATEVALUE(CONCATENATE(CONCATENATE(CONCATENATE(Table1[Month],"/"),CONCATENATE("01","/")),Table1[Year]))


Thanks,
Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Brill thanks Lydia