Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a table which displays measures by User.
Example :
- User | NB created contacts | NB created opportunities | NB created appointments
The client wants to filter by date of creation. Each entity (contact, opportunity, appointment) have a createdon field.
I don't know if it's possible to add a date filter and filter on all the measures when the user choose the between dates.
Until now, I used a slicer and made the field "beteen two dates" but in my scenario, I need one field date than can filter on all my measures.
Thanks,
Hi,
The data will have to be transformed (specifically Unpivoted) to create one Date column from the 3 Date columns. To get further help, share some data and show the expected result.
That seems like standard functionality. What have you tried and where are you stuck?
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |