Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'd like to create a measure with a set-expression that excludes data that is above a certain date and the date may not be NULL. I can't seem to figure is out.
The function is: Sum({$<[Datum betaald - Date]={">03-07-2018"}>}[Datum betaald - Date]-Factuurdatum)
I'd like to add exclude NULL values for the same field.
Thanks in advance
hi
when you use the higher than something in your set analysis you automatically also exclude the null values from the field