Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
In Urgent Need!
Problem statement:
Request to be able to find Opportunities that haven’t been updated recently. I was thinking that we could accomplish by adding a ‘Before’ option to the “Last Updated Date” filter? The ‘Before’ option would filter records where the “Last Updated Date” value is [x] amount of [days, weeks, months, etc] before the current date. (Refer below Image)
But adding a before in the Relative date is not possible so, Is there feasibility to add this requirement??
Pbix attached hereby.
Thanks in advance:)
Hi @SUMESHKUMAR22 ,
If I am understanding your issue, why not just put a filter on the date visual to only get x amount of days before curent date? That would be just in the filter pane and not "in" the visual but it should do what you want.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @SUMESHKUMAR22 ,
Ok, I think I understand. So, you will probably need to do a DAX field to get that date range and then use it. So, it would be something like this (I have not had time to test this but the point is to get the dates in the selected period in your slicer and then get the previous 30 days only).
30DaysOut = CALCULATE(('Table Name'[Field name]),DATESINPERIOD('Date Dim'[Date],NEXTDAY('Date Dim'[Date])-30,DAY))
Proud to be a Datanaut!
Private message me for consulting or training needs.
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |