topic Re: Help needed in DAX Commands and Tips

Help needed

Anonymous — Thu, 03 Feb 2022 18:12:12 GMT

Hi All,

please see below data table , I'm supposed to compute task completed not completed ,so if the end date is within the same week ending as last weeks ending then it should show complete else not complete. Tasks are repetitive as every week new table will have historic records as well. I need help with either calculated column or dax

task id	Week ending	Start Date	end date
klju	09/01/2022	01/06/2021	17/01/2022
lout	09/01/2022	02/06/2021	18/01/2022
klout	09/01/2022	03/06/2021	19/01/2022
klju	09/01/2022	04/06/2021	20/01/2022
lout	16/01/2022	05/06/2021	21/01/2022
klout	16/01/2022	06/06/2021	22/01/2022
klju	16/01/2022	07/06/2021	23/01/2022
lout	23/01/2022	08/06/2021	24/01/2022
klout	23/01/2022	09/06/2021	25/01/2022
klju	23/01/2022	10/06/2021	26/01/2022
lout	30/01/2022	11/06/2021	27/01/2022
klout	30/01/2022	12/06/2021	28/01/2022
klju	30/01/2022	13/06/2021	29/01/2022
lout	30/01/2022	14/06/2021	30/01/2022

Kind Regards

Re: Help needed

Jihwan_Kim — Fri, 04 Feb 2022 04:15:59 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below.

It is for creating a calculated column.

Result CC =
IF ( Data[end date] <= Data[Week ending], "Complete", "Not complete" )

Re: Help needed

v-yalanwu-msft — Wed, 09 Feb 2022 08:50:13 GMT

Hi, Anonymous ;

Try to create a column.

Column = IF( WEEKNUM([Week ending],2)=WEEKNUM([end date],2),"complete","Not complete")

The final output is shown below:

Please correct me if I have misunderstood and let me know what your logic is? Looking forward to your reply.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.