Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Entering Data using date column as a filter

Hello,   I have the following dataset, where PK_Date represents a date column of every date from 2015-2020. In the column SHIP_UNITS_BY_UOM, values will either be non-zero or blank(). I would like ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Anonymous,

     

    You can try to use below formula if it works for your scenario:

    Measure =
IF (
    MAX ( D_Date[PK_Date] ) < TODAY ()
        && SUM ( 'F_INVOICE'[SHIP_UNITS_BY_UOM] ) = BLANK (),
    SUM ( 'F_INVOICE'[SHIP_UNITS_BY_UOM] ) + 0,
    BLANK ()
)

    If my formula not help, please share some sample data to test and coding formula.

     

    Regards,

    Xiaoxin Sheng