Need to merge the date between two tables without any link into the data model.

[mcaahmad93]

Hi Team,

I need one help from your side. I have two tables, table 'A' and table 'B' if we load the data into data model, there should not be any link between both tables A and B. In the front end, we need  a year and month column based on year and month column both table data should be changed.

Note: I am using the below expression to combine both the data tables, but year and month is coming double time. If you have any better suggestion, please advise me. 

=Date([Sales date]) &' - '& date([Profit Date])

Regards,

Irshad Ansari

[Anil_Babu_Samineni]

Perhaps this?

Date(Floor([Sales date] &' - '& [Profit Date]))

Or

Date(Date#(Floor([Sales date] &' - '& [Profit Date]), 'Your Format Here'))

[mcaahmad93]

Dear Anil,

Thank you for you valuable time.

I tried your expression but it not working for me. 

I am using the below expression for month and year.

Month:=Month(date([Sales date])) &' - '& Month(Date([Profit Date]))

Year:=Year(date([Sales date])) &' - '& year(Date([Profit Date]))

And getting the Expected result like this.

But i need actual result like this format for month and year which i am not getting.

Thanks

Irshad Ansari

[Anil_Babu_Samineni · Accepted solution]

Because, You are clubbing 2 fields. It will give always that only. Blindly do this to get result?

Month:=SubField(Month(date([Sales date])) &' - '& Month(Date([Profit Date])), '-' ,-1)

Year:=SubField(Year(date([Sales date])) &' - '& year(Date([Profit Date])), '-' ,-1)

[mcaahmad93]

Dear Anil,

Based on your expression i am getting the output but data reflecting only one table. It should be reflect both table profit details and sales details.

Regards,

Irshad Ansari

[Vignesh1609]

Do you have any idea in Forecast report?