Getting latest date and some calcualtions

[Anonymous]

I am facing 1 issue on this below requirement. My dataset have date value field created, my requirement is i want a calculated column which shows the valus based on this condition

within this week : latestdate(created)-created <=7

within 1 to 2 week : latestdate(created)-created>7 and<14

like that

pls help on this 

[az38 · Accepted solution]

Hello, ZRS3042

If I understand you correct try this 

Column = if(MAX('Table'[Date])-'Table'[Date] <= 7; "within this week"; if(AND(MAX('Table'[Date])-'Table'[Date] > 7;MAX('Table'[Date])-'Table'[Date] <= 14); "within 1 to 2 week"))

[az38 · Accepted solution]

Hello, ZRS3042

If I understand you correct try this 

Column = if(MAX('Table'[Date])-'Table'[Date] <= 7; "within this week"; if(AND(MAX('Table'[Date])-'Table'[Date] > 7;MAX('Table'[Date])-'Table'[Date] <= 14); "within 1 to 2 week"))

[Anonymous]

Thanks I will work on it

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

Have you worked it out? If so, would you please kindly mark the helpful reply as an answer?

Regards,

Yuliana Gu