HOW TO CONNECT 2 TABLE(DATA) WITH DIFFERENT DATE COLUMN AND USE AS FILTER

[RanHo]

 Good Day!


  I have a sample problem here, I want to get the total counts/number of data in a specific month , but the data (Production/claims) has 2 different date columns like the ff:



any ideas and advice for this problem?

Thanks in advance.

-Ran

[Idrissshatila · Accepted solution]

Hello @RanHo ,

You create a dim date table between these two tables that you link both tables to and filter through it.

check this out https://youtu.be/2f7dYB1l84g

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[RanHo]

@Idrissshatila Thanks for the answer, I'll take it as an answer/solution.


 As for anyone having problem like this , check out this link too: https://www.youtube.com/watch?v=TnyRsO4NJPc