Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
All,
I am working on a report that will allow my company to look at both vendor and customer payments within the last 5 days, and I am looking for a way that I can create this logic using DAX. If we could just do the most recent five days only, the relative filter function would be perfect, but unfortunately that is not what our user is requesting.
Basically, the user wants to be able to make a date selection at any point in time within the data set and and immediately filter to the five days preceding that selected date.
Additionally, we are hoping to sort and limit the lists to the top 10 payments (by amount) from each category.
Would love the help from the community on where to get started with this ask.
Hi @Anonymous ,
Is this problem solved?
Best Regards,
Icey
Hi @Anonymous ,
If I understand you correctly, you can refer to this post:
Display Last N Months & Selected Month using Single Date Dimension in Power BI.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Well, you could use a TopN filter for that second part. For the first part, you could structure your measures like this:
Measure =
VAR __Date = SELECTEDVALUE('Table'[Date])
VAR __5DaysAgo = (__Date - 5) * 1.
VAR __Table = FILTER('Table',[Date] >= __5DaysAgo && [Date] <= __Date)
RETURN
<Some calculation across __Table>
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |