Forum Discussion

jay_patel's avatar
jay_patel
Helper IV
4 years ago

How to consider blank dates while calculating amount based on the date column

Hello All,

I have a dax 

OverDue Amt for BSID =
var _max = maxx('Calendar','Calendar'[Date])
var _m = Calculate(sum('Master Data'[Final amount]),'Master Data'[NetDueDate] <= _max)
return
_m
and the results is not getting match with the model , And may be it's just because it is not considering Blank Dates of 'NetDueDate'  Column.

Please help, if there is any way to do the same.

Thanks in advance!


Need Help

2 Replies

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    BLANK() < DATE(2022,01,01) = true
    so it's something else.
    Please share more info

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi jay_patel ,

    Please have a try. Modify the dax.

    OverDue Amt for BSID =
VAR _max =
    MAXX ( 'Calendar', 'Calendar'[Date] )
VAR _m =
    CALCULATE (
        SUM ( 'Master Data'[Final amount] ),
        'Master Data'[NetDueDate] <= _max
    )
RETURN
    IF ( ISBLANK ( 'Master Data'[NetDueDate] ), 0, _M )

     If I have misundstood your meaning, please provide your desired output and pbix file without privacy information.

    How to Get Your Question Answered Quickly 

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.