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 a table with invoice data. Each date has quantity invoices and I need to show only the most recent value.
One column is "Invoice Date"
Another column is "Quantity"
Another calculated column I wrote is "Consolited Item"
Another Column is "Organization Name"
I need to write a measure that shows the sum of the most recent quantity invoiced.
So, for Organization X if their last invoice was sent July 30th, what was the quantity of servers?
That will depend some on your data. If the rows in your datasource are in order by date, you can use the LASTNONBLANK function in DAX to return the most recent record for each Date. Or you could set a filter in your table visualization that only returns MAX 1 invoice by Date.
Here's my suggestion based on your update:
Then you can create a table which will show you the max Date for any given Organization Name, and the latest Quantity that was invoiced on that date.
This may run into problems if you have multiple invoices a day. In that case, your Date column would need to include the time as well; then it will work fine.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |