Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to show only null records in straight table for the column Agreed delivery date.
I am using below mentioned expression in measure.
=IF(IF(InList=1,(MAX({<[SDLNTY - Line Type]={'S'}>}[SDURDT - Date - Agreed Delivery])-MIN({<[SDLNTY - Line Type]={'S'}>}[SDURDT - Date - Agreed Delivery])),0)>0,'Multiple Dates')
PFA.
You may try using the reverse condition in IF, like:
If( <expression> <=0, '-') // or, you can use null() instead of '-' depending upon effect of the default suppress nuisance
How do I remove that 'Multiple Dates' records from the table. I need to remove that whole rows.