Forum Discussion
Helper IIDate 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.
Super Useriiomarioii
Try this as new column:
Positive =
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 🙂
iiomarioiiPositive =IF([Date] =CALCULATE(MAX('Date'[Date]),ALLEXCEPT(Table1,Table1[item number]),[Quantity]>0),[Date],BLANK())Thank you! I get 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.- Fowmy
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 🙂
- iiomarioii
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.