Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

(direct query) creates a group interval from the difference between 2 dates

Hi teams

i have a report connected to PostgreSql using direct query, and i need to create a group based on difference between current time and admision date, comes out like in this visual.

 

 

 

 

 

and this is my data, 

 

is anyone can help me to solved it?

 

thank you

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    hi V-lianl-msft 

     

    sorry for late respond, 
    thanks for your help, 

     

    But i ran into another problem after implement your way

     

     for workaround, i try creating query script with DATE_PART function in SQL editor

     Thanks for your help btw.

2 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Create a calculated column like this:

    group_ = var days = ABS(DATEDIFF(Table_5[date1],Table_5[date2],HOUR))/24
return SWITCH(TRUE(),
0<days&&days<1,"<1 day",
1<days&&days<2,"1-2 days",
">2 days")

    Sample .pbix

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      hi V-lianl-msft 

       

      sorry for late respond, 
      thanks for your help, 

       

      But i ran into another problem after implement your way

       

       for workaround, i try creating query script with DATE_PART function in SQL editor

       Thanks for your help btw.