Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Help needed

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 idWeek endingStart Dateend date
klju09/01/202201/06/202117/01/2022
lout09/01/202202/06/202118/01/2022
klout09/01/202203/06/202119/01/2022
klju09/01/202204/06/202120/01/2022
lout16/01/202205/06/202121/01/2022
klout16/01/202206/06/202122/01/2022
klju16/01/202207/06/202123/01/2022
lout23/01/202208/06/202124/01/2022
klout23/01/202209/06/202125/01/2022
klju23/01/202210/06/202126/01/2022
lout30/01/202211/06/202127/01/2022
klout30/01/202212/06/202128/01/2022
klju30/01/202213/06/202129/01/2022
lout30/01/202214/06/202130/01/2022

 

Kind Regards

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

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:

vyalanwumsft_0-1644396535956.png

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.

View solution in original post

2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

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:

vyalanwumsft_0-1644396535956.png

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.

Jihwan_Kim
Super User
Super User

Hi,

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

It is for creating a calculated column.

 

Picture1.png

 

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

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors