Forum Discussion
Need Help writing a DAX Formula that returns distinct values based on max date
Hello everyone, i need your help in writing a DAX Formula that returns distinct values for a row, based on max date that is smaller or equal to the value chosen in a slicer. So i have a DataTabl...
FreemanZ
Super User
Super Userhi CarMechanic
try to plot a table visual with Customer and Name columns and two measures like:
LoadtimeLast =
MAX(DataTable[Loadtime])
PostalCodeLast =
MAXX(
FILTER(
DataTable,
DataTable[Loadtime]=[LoadtimeLast]
),
DataTable[Postal Code]
)
hello FreemanZ ,
thanks for the fast response.
Unfortunately this solution doesnt cover all the changes that can happen in a row. The tables i have posted are only examples. The real data rows consist of 30 columns with different attributes. Whenever one of the attributes changes, a new row with new loadtime will be added for a customer. So the solution must be more flexible than that. But thanks 🙂