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.    ...
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.

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.