How to write dax query about last 2 weeks employee completed tasks in project?

[Anonymous]

Dax query : last 2 weeks emp cmmpleted work in project

[v-yuta-msft]

Hi kunuthuri ,

As a general solution, you can create a measure using dax like this pattern:

Result =
VAR Last_Two_Week =
    MAX ( Table[Date] ) - 14
RETURN
    CALCULATE (
        aggregation,
        FILTER (
            Table,
            Table[Date] > Last_Two_Week
                && Table[Date] <= MAX ( Table[Date] )
        )
    )

Regards,

Jimmy Tao

[Anonymous]

Hi

Thanks to reply,

How to display values from 'Title' Column whose completed date in last 2 weeks?

[v-yuta-msft · Accepted solution]

Hi kunuthuri,

Create a measure using DAX as below:

Less than 2 weeks =
CALCULATE (
    MAX ( Table1[Title] ),
    FILTER ( Table1, Table1[Date] <= TODAY () - 1 && Table1[Date] >= TODAY () - 15 )
)

 

Regards,

Jimmy Tao

[Anonymous]

Thanks Jimmy Tao

Its working fine

[Anonymous]

Hi

From todays date to next 14 days new task and active data display like below examples

column = IF(Table1[column]="New" && table1[column]<=today+14, table1[column])

above calculated column is correct to retrieve data next 14 days data?

Thanks

Kunuthuri

[garvicasas]

in some other post i think they solved this for you in the comments, why not check them?

Also, why not write all in just one post?

this is a spamming helping

[jthomson]

This seems awfully similar to the previous five or six threads you've started, but you've not actually given any clear idea of what you're doing in any of them

[Anonymous]

Every day display data based on todays date, means if we see data today, today to last 2 weeks and tomorrow we see data tomorrow onwards 2 weeks need to display

Can you please assist?

Thanks

Kunuthuri