Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I try to filter a column based on its value and date range.
Case description:
A sales person is already in database, but from this month we want to have her in the report. Basically we want to filter out the historical data related to her. How could I do this?
There is a relation between Sales table and Date table on Date.
Thanks,
@amitchandak Hi and thanks for the reply on my question. The relationship is abctive! What I need is a formula/measure I can use to filter on a particular Sales person from this month and after!
If you want the data to be included in your visual for that particular perosn, you need to refresh your report.
If you are looking for a way to visualise the data for that particular person, create a measure like the below:
You can also use a Slicer with name of the Sales Person and use that to view the data if that particular person.
Hi @PC2790 and thanks,
But my question is if to filter this person by date as well?
Let's say I need to have Mark in total sales from september and NOT before september.
Thanks
@Anonymous , if sales and date table are joined with each other and have active join then it should filter using that active join when you filter date table. for inactive join, you have to use userelationship
User | Count |
---|---|
77 | |
74 | |
60 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |