Solved: Time range filter

Anonymous · ‎10-31-2020

I have a table as below

Groups	12 AM	1 AM	2 AM	3 AM	4 AM	5 AM	6 AM	7 AM
G-SUPPORT	322	277	180	143	101	94	134	77
A-SUPPORT	104	23	46	48	60	57	35	33
B-SUPPORT	14	19	19	38	38	16	53	10
F-SUPPORT	349	260	232	271	136	193	178	110

we have three shifts from 12 - 2 , 2 -4 and 4- 7 AM, i created a shift table as below

ID	shift _desc	Type
1	12 AM - 2 AM	1 st
2	2 AM - 4 AM	2nd
3	4 AM - 7 AM	3rd

I want to create a filter for shift_desc. When i select 12 AM - 2AM check box i want above table to display in range 12 AM - 2 AM.How can i do this?

CNENFRNL · ‎10-31-2020

Hi, @Anonymous , in order to apply filter to a range of time, I convert the tables given that DAX functions in a column-wise manner.

Then slicer works easily,

You might want to refer to the attached file for more details.

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

CNENFRNL · ‎10-31-2020

Hi, @Anonymous , in order to apply filter to a range of time, I convert the tables given that DAX functions in a column-wise manner.

Then slicer works easily,

You might want to refer to the attached file for more details.

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!