Forum Discussion
Date when value is negative
Hi iiomarioii,
Try add filter to the formula.
positive = IF ( 'Gesamt2'[Date] = CALCULATE ( MAX ( 'Date'[Date] ), FILTER ( ALLEXCEPT ( Tablle1, 'Tablle1'[Artikelnummer] ), [total] >= 0 ) ), 'Gesamt2'[Date], BLANK () )Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
iiomarioii
I added it as a column and it can be used as a measure as well. You can add the new column as a filter in Visual filter and set it to <>=Blank to show only those records that meet the condition.
Check the File: https://1drv.ms/u/s!AmoScH5srsIYgYIMjN8BuD99S0yuAA?e=XvlDMf
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
I ve tried your approach. Im still getting this error, when I use the date column fromthe date table:
When using the date column in the table with the quantities, I'm getting this error:
Thank you for your help.
iiomarioii
Use this measure if you have calendar Table:Positive Calendar = VAR _Date = MAX('Calendar'[Date]) RETURN IF( _Date = CALCULATE( MAX(Table1[Date]), ALLEXCEPT(Table1,Table1[Item number]), Table1[Quantity]>0 ), _Date, BLANK() )________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
Fowmy Thank you
I'm still getting this error:
A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.