Forum Discussion

JMHenriques's avatar
JMHenriques
Frequent Visitor
2 years ago
Solved

get working days since datetime until NOW with decimals

Hi all,   I have a Calendar Table with IsWeekend and a table with a "created_at" column in Datetime format.   I need to count the days and hours passed since the "created_at" until the refresh da...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi JMHenriques ,

     

    Thanks to CKN  for the idea.

    JMHenriques Your Tickets table are being filtered because you're using a slicer about “created_at”. When you select a value in the slicer, Tickets table is filtered. If you want to disable this filtering, you can use the Edit Interaction feature.

     

     

    Best regards,

    Mengmeng Li

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JMHenriques ,

 

Thanks for CKN 's reply.

JMHenriques You'll also need to adjust the number of decimal places if you want the results to be displayed in decimal format.

 

If you want to calculate the number of hours from the “created_at” of each row to now and the results are displayed as decimals, you can refer to my test.

Measure.

DateDiff = DATEDIFF(MAX('Calendar'[created_at]),UTCNOW(),MINUTE)/60

 

 

 

 

Best regards,

Mengmeng Li

JMHenriques's avatar
JMHenriques
Frequent Visitor
2 years ago

Thank you Anonymous, that part worked perfectly for the decimals but I still cannot find a way to make what CKN suggested of subtracting the weekends... I'am trying to use the COUNTROWS and filter to exclude weekends but no joy for now

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi JMHenriques ,

     

    Thanks to CKN  for the idea.

    JMHenriques Your Tickets table are being filtered because you're using a slicer about “created_at”. When you select a value in the slicer, Tickets table is filtered. If you want to disable this filtering, you can use the Edit Interaction feature.

     

     

    Best regards,

    Mengmeng Li