Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 wee...
Need Help
  • az38's avatar
    az38
    7 years ago

    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"))
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

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

     

    Regards,

    Yuliana Gu

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Thanks I will work on it

 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous ,

     

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

     

    Regards,

    Yuliana Gu