combine date columns

[Haroon123670]

i have 1 google sheet which contain 2 dates column 1 is ARV_INITIATION_DATE and the other is DEATH_TRANSFER_DATE i date column is used for tracing how much patients registered in 1 year and other date column is used for deceased and transfer patients i want to combine these 2 columns so i can make a slicer so you just have to clinick an year and all the activties done in that year should show on dashboard Power bi

[Haroon123670]

 HAVE TO 2 DATE COLUMN WHICH I WANT TO COMBINE 1 IS REG_Date and the other is DEATH_TRANSFER_DATE I want to make a 1 slicer from it so it should give me a separate count of HRG IDU, TG, MSM, and MSW, I FSW, I GP I AND AND DEATH_TRANSFERED_PATIENT STAUS ARV/DEATH,PARV/DEATH AND TRANSFER PATIENT 

[Haroon123670]

MY DATE BASE IS LIKE THIS 

  

  

  

[Ahmedx]

it seems to me that it is enough to create a calendar and connect it with two capitals, one connection will be active and the second activate it using a measure

[Haroon123670]

THNAK YOU SOO MUCH OF YOUR TIME BUT CAN I HAVE DAX SOLUTION FOR THAT 

[Idrissshatila]

Hello @Haroon123670 ,

You could append the two columns to make them in one table.

check this https://learn.microsoft.com/en-us/power-query/append-queries

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

Follow me on Linkedin

[Haroon123670]

THANK YOU SOO MUCH OF YOUR TIME BUT CAN I HAVE DAX SOLUTION FOR THAT 

[Idrissshatila]

Hello @Haroon123670 ,

then check this solution https://community.powerbi.com/t5/Desktop/Append-tables-with-same-columns-using-DAX/m-p/3115539

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

Follow me on Linkedin

[Haroon123670]

MY COMBINATION OF 2 DATES ARE LOOKING LIKE THIS BUT I WANT ALL MY DATES AT TOP OF EACH OTHER NOT VERTICAL OR SIDE BY SIDE