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.
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
Super UserAnonymous - 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.