Combining Columns in Powerpivot

[ehardway123]

Hello,

So I am trying to combine columns in powerpivot to create the whole invoice date. I have three columns that have invoice year, invoice day and invoice month. I want to combine it to give me the full date in one column so I can be able to filter by a date range. What function do I use? I have tried using DATE function but it is giving me an error.


Thanks,

Erica

 

[Norah]

The DATE function should work. Have you made sure that the columns don't have blanks or text? Assuming your table's name is Invoices, this formula should work:

=DATE(Invoices[Invoice Year], Invoices[Invoice Month], Invoices[Invoice Day])