Find last two weeks data based on work provided to employee?

[Anonymous]

Hi

how to find last two weeks data (Name column) based on work given to employee whether they completed or pending ?

Required only completed data?

Like Busy - completed

       Docs - completed 

How to write DAX query?

can you please assist?

Thanks

Kunuthuri

[v-danhe-msft]

Hi @Anonymous,

could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my test, you can refer to below steps:

1.I have entered some sample data:

2.Create two calculated columns and now you can see the result.

Weeknum = WEEKNUM('Table1'[Date])

Last 2 weeks = IF('Table1'[Work]="completed"&&Table1[Weeknum]=MAX('Table1'[Weeknum])  ||  Table1[Weeknum]=MAX('Table1'[Weeknum])-1,[Name])

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/czxooyz6k5kzb87/Find%20last%20two%20weeks%20data%20based%20on%20work%20provided%20to%20employee.pbix?dl=0

Regards,

Daniel He