Forum Discussion
Last Date Supplied DAX Help Please
Anonymous - It's showing against Process Dates where the result is BLANK this is the same as 0. Notice it does not show on 22/10/2024 where the value is above 0.
You could apply a filter to this table to remove the BLANK rows from PO QTY Sent.
Super UserAnonymous - Try this
IF(
[PO QTY Sent] > 0,
BLANK(),
CALCULATE(
MAX(PurchaseOrder[ProcessDate]),
FILTER(
ALL(PurchaseOrder[ProcessDate]),
[PO QTY Sent] > 0)))
If this works, please accept as the solution to help others with the same issue
Hi Mark,
Its almost there its just showing me 22/10/2024 against every date now though as per below. Rather than using the original screenshot as an example. i would need it to show me 22/10/2024 on just the top 3 lines as [PO QTY Sent] is 0
- mark_endicott
Anonymous - It's showing against Process Dates where the result is BLANK this is the same as 0. Notice it does not show on 22/10/2024 where the value is above 0.
You could apply a filter to this table to remove the BLANK rows from PO QTY Sent.
mark_endicott thanks Mark, im just going to remove the blank out of the dax, and use a visual filter to remove the blanks from the table.