count data between date hours (24 hrs, 48 hrs etc)

[Anonymous]

Hi

How to write DAX Expression above example, Requirement is " based on Name(A,B,C) between date hours-  below 24 hrs same day, above 24 hrs - below 48 hrs display (24hrs) etc... dsiplay the count of numbers?

Thanks

Kunuthuri

[v-chuncz-msft]

@Anonymous,

You may use DATEDIFF Function and SWITCH Function to add a calculated column.

https://community.powerbi.com/t5/Desktop/Get-Last-6-months-And-Next-6-months-from-current-month/m-p/199136#M87611

[Anonymous]

Hi

Thanks to reply

The query link you send working fine, but when we taking to matrix visual . Which data drag to Rows, Columns and values. Can you please assist it.

Thanks

kunuthuri