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'm trying to get the most recent date of my purchase in on my table showing my products on stock.
I would like to show my latest purchase date on each item listed in my stock report, so I have a complete overview on how old my stock is.
I have tried with LASTDATE or MAX, but can't seem to make it work.
All my purchase data is located in my table LAGPOST (2).
Any good suggestions?
Solved! Go to Solution.
This solution is OK and working on my data.
Just try to create the table from scratch and you can use matrix table too for clear understanding.
Also, there is an alternate formula which is similar,
Measure =LASTNONBLANK(TableName[Date],MAX(TableName[Date]))
and you can also put the Date Column into the Table and Choose Latest
Hi @Lautorp
Try this pattern
= CALCULATE ( MAX ( TableName[Date] ), ALLEXCEPT ( TableName, TableName[Products] ) )
It looks like it just return the higest number in the date coloum.
This solution is OK and working on my data.
Just try to create the table from scratch and you can use matrix table too for clear understanding.
Also, there is an alternate formula which is similar,
Measure =LASTNONBLANK(TableName[Date],MAX(TableName[Date]))
and you can also put the Date Column into the Table and Choose Latest
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |