How to find hours range

Anonymous — Tue, 23 May 2023 07:28:31 GMT

Hi Team,

have one question ..... how we can configure the below range in one measure , please check and guide me

<=3 hrs

3-8 hrs

8-12 hrs

12-24 hrs

>24 hrs

Thanks,

Krishna

Re: How to find hours range

SamInogic — Wed, 24 May 2023 06:03:19 GMT

Hi Anonymous ,

We are bit unclear with your table structure where you capture the Hours data, so we have considered below table which holds hours value,

Also, the Slicer to filter these hours, we have created a table with options you mentioned as shown in below screenshot.

In order to filter the data based on selection you need to create a Measure in Data table with DAX expression as:

Filter Hours = SWITCH(SELECTEDVALUE(Hours[Hours]), "<=3 hrs", IF(SELECTEDVALUE(Data[Data Hours])<=3,"In","Out") ,

"3-8 hrs",IF(SELECTEDVALUE(Data[Data Hours])>3 && SELECTEDVALUE(Data[Data Hours])<8,"In","Out")

,"8-12 hrs",IF(SELECTEDVALUE(Data[Data Hours])>=8 && SELECTEDVALUE(Data[Data Hours])<12,"In","Out"),

"12-24 hrs",IF(SELECTEDVALUE(Data[Data Hours])>12 && SELECTEDVALUE(Data[Data Hours])<=24,"In","Out"),

">24 hrs",IF(SELECTEDVALUE(Data[Data Hours])>24,"In","Out")

This will check the selected value in the slicer i.e. filter and based on current value of table row validate the hours falls within selected range or out of the range.

Please refer to the below screenshot for the same.

Now in order to filter the table for respective data to be displayed in table as per the range selection we need to add filter to the table as Filter Hours = In as shown in the below screenshot.

If this answer helps, please mark it as an Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service: http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/

topic How to find hours range in DAX Commands and Tips

How to find hours range

Re: How to find hours range