Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a database with multiple tables that contain start and end date for employee details, I want to allow users to select a key date and display the data that the date falls into. What's the best way to go about this?
Say we have:
Employees
-- Employee Unique ID
-- Name
Position
-- Employee Unique ID
-- Position Title
-- Employment Status
-- Start Date
-- End Date
Performance Score
-- Employee Unique ID
-- Score
-- Start Date
-- End Date
Thanks!
Solved! Go to Solution.
in general the method for user selection is via the Slicer; some good video tutorials on using these. You can have multiple within a page of a report. So I would first check out that information.
I can understand the idea of "slicing & dicing" data sets - but have always thought a more accurate name would be a Filter Selector......
make your first stab with these and then post if you need further assist.
@PauloH wrote:
Hi,
I have a database with multiple tables that contain start and end date for employee details, I want to allow users to select a key date and display the data that the date falls into. What's the best way to go about this?
Say we have:
Employees
-- Employee Unique ID
-- Name
Position
-- Employee Unique ID
-- Position Title
-- Employment Status
-- Start Date
-- End Date
Performance Score
-- Employee Unique ID
-- Score
-- Start Date
-- End Date
Thanks!
You can create a independent calendar table used in the slicer and create a measure as
isShown = IF ( ISFILTERED ( 'calendar'[Date] ), IF ( MAX ( 'calendar'[Date] ) >= MAX ( Table1[start date] ) && MAX ( 'calendar'[Date] ) <= MAX ( Table1[end date] ), 1, BLANK () ), 1 )
To filter data, you can use a filter like
FILTER(yourTable, yourTable[start date]<= MAX(calendar[date])&&yourTable[end date]>= MAX(calendar[date]))
See the attached pbix file.
@PauloH wrote:
Hi,
I have a database with multiple tables that contain start and end date for employee details, I want to allow users to select a key date and display the data that the date falls into. What's the best way to go about this?
Say we have:
Employees
-- Employee Unique ID
-- Name
Position
-- Employee Unique ID
-- Position Title
-- Employment Status
-- Start Date
-- End Date
Performance Score
-- Employee Unique ID
-- Score
-- Start Date
-- End Date
Thanks!
You can create a independent calendar table used in the slicer and create a measure as
isShown = IF ( ISFILTERED ( 'calendar'[Date] ), IF ( MAX ( 'calendar'[Date] ) >= MAX ( Table1[start date] ) && MAX ( 'calendar'[Date] ) <= MAX ( Table1[end date] ), 1, BLANK () ), 1 )
To filter data, you can use a filter like
FILTER(yourTable, yourTable[start date]<= MAX(calendar[date])&&yourTable[end date]>= MAX(calendar[date]))
See the attached pbix file.
in general the method for user selection is via the Slicer; some good video tutorials on using these. You can have multiple within a page of a report. So I would first check out that information.
I can understand the idea of "slicing & dicing" data sets - but have always thought a more accurate name would be a Filter Selector......
make your first stab with these and then post if you need further assist.
This had no relevant info to the question - not a solution
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |