cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ZRS3042 Frequent Visitor
Frequent Visitor

Getting latest date and some calcualtions

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 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
az38 Regular Visitor
Regular Visitor

Re: Getting latest date and some calcualtions

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"))
Community Support Team
Community Support Team

Re: Getting latest date and some calcualtions

Hi @ZRS3042 ,

 

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

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Highlighted
az38 Regular Visitor
Regular Visitor

Re: Getting latest date and some calcualtions

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"))
ZRS3042 Frequent Visitor
Frequent Visitor

Re: Getting latest date and some calcualtions

Thanks I will work on it

 

Community Support Team
Community Support Team

Re: Getting latest date and some calcualtions

Hi @ZRS3042 ,

 

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

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.