Forum Discussion
combine date columns
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
8 Replies
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 👍
THANK YOU SOO MUCH OF YOUR TIME BUT CAN I HAVE DAX SOLUTION FOR THAT
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 👍
THNAK YOU SOO MUCH OF YOUR TIME BUT CAN I HAVE DAX SOLUTION FOR THAT
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
MY DATE BASE IS LIKE THIS
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
