Forum Discussion
Create a measure that only filters based on 2 fields
Super UserGeorge375 , Not very clear, see if these can help
Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Here is an example of what my situation is. Basically I have a log of historical data with order #, transaction date, item code and customer number. I want on each line a measure that shows the latest date that item went to that customer. But becuase the order # and date field are in the visual, the measure filters only on those dates when in the table so shows the undesired dates as seen on the example table. Want to know what dax would help me get a table like my goal and not what im currently getting
Goal:
| Order Number | Transaction Date | Item Code | Customer Number | Latest Date |
| 1 | 1/1/2022 | ABC | 123 | 1/4/2022 |
| 2 | 1/2/2022 | ABC | 123 | 1/4/2022 |
| 3 | 1/3/2022 | ABC | 123 | 1/4/2022 |
| 4 | 1/4/2022 | ABC | 123 | 1/4/2022 |
What Im getting on PBI:
| Order Number | Transaction Date | Item Code | Customer Number | Latest Date |
| 1 | 1/1/2022 | ABC | 123 | 1/1/2022 |
| 2 | 1/2/2022 | ABC | 123 | 1/2/2022 |
| 3 | 1/3/2022 | ABC | 123 | 1/3/2022 |
| 4 | 1/4/2022 | ABC | 123 | 1/4/2022 |