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.
I have used the method descibed in this link to do date range comparisons for sales but now I need to return a list based on the code.
https://medium.com/chandakamit/power-bi-comparing-data-across-date-ranges-36be49b68613
Here is what my measure looks like currently:
Solved! Go to Solution.
Try to create a measure and apply it to visual level filter.
measure = if(max(OPENDET [ORDER DATE]) in values('Date'[Date]),1,0)
Try to create a measure and apply it to visual level filter.
measure = if(max(OPENDET [ORDER DATE]) in values('Date'[Date]),1,0)
Sorry i do not see how this plugs into my original formula. I have tried a few differetn ways but am only getting the max value which is the most recent date. What i need is to have the results of the table narrowed by the date slicer from the original formula because many other elements of my report are linked to those date slicers.
Hi @gaiusgw
Can you please give an example of the result you want.
Regards
Phil
Proud to be a Super User!
Hopefully this screenshot clear things up. I am trying to make it so that results in the invoice box are narrowed down by date range. However, the date range method I am using makes it so that dates cannot have a relationship between databases. So i am looking to plug into the code in my original post.
Hi @gaiusgw
The List of Unique ID's can be created with this
List Unique IDs =
CALCULATE(CONCATENATEX(DISTINCT(OpenDet[CustNumber]), ('OpenDet'[CustNumber]),", "))
and the count with this
Count Unique IDs = DISTINCTCOUNT(OpenDet[CustNumber])
Regards
Phil
Proud to be a Super User!
Hey Phil,
Thanks for examples and the file! However, I may has misspoke when I said "list" of unique returns. What I meant was narrowing down a table of IDs based on the date formula I am curretly using.
The count part is what I needed for count though so that great. Thanks a lot.
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 |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |