How to make two date columns into a single column of date/data to visualize units/cost

[sivarajan21]

Hi Dear Community experts,

I have the following issue of creating only one column out of these 2 date columns in Power BI query editor.

I need two columns to show in visualization out of which one is Units column which is already present here readily.

But I am having hard time in converting this two date columns(Date,Date_previous) into a single column in query editor.

This single column may be in any format like periods, dates etc.

I have attached the screen shot here of the source file.

I want it to look like below (but necessarily month, it can be spread into 13 periods or full dates etc)

Looking forward to your response.

Cheers,

Siva

[sivarajan21]

Hi Guys,

I would appreciate your help on this?

Cheers

[Mahesh0016]

@sivarajan21 
Try this if helpful...
Date.From((Number.From([Date1]) + Number.From([Date2]))/2)

[sivarajan21]

Hi Mahesh, 

Thanks for your prompt response, Is there any other different solutions that I can try in Dax?