Forum Discussion
Solved
Concatenate dates
Hello everyone. When I try to concatenate 3 columns, one of them has dates, I get in the results column a number that equales a date. Very annoying. My column formula =CONCAT([@[Name]],"-",...
In DAX
you may use
=CONCATENATE(Table1[Name],CONCATENATE("-",CONCATENATE(Table1[Record Number],CONCATENATE("-",Table1[Expiration Date]))))but much better is
=Table1[Name] & "-" & Table1[Record Number] & "-" & Table1[Expiration Date]
I am now trying to do this in a Power Pivot table, it does not accept more than 2 arguments. How can I do this in power pivot.
In DAX
you may use
=CONCATENATE(Table1[Name],CONCATENATE("-",CONCATENATE(Table1[Record Number],CONCATENATE("-",Table1[Expiration Date]))))but much better is
=Table1[Name] & "-" & Table1[Record Number] & "-" & Table1[Expiration Date]