Forum Discussion

refint_650's avatar
refint_650
Helper I
4 years ago
Solved

conditions date expression

Hi all  how to implement this dax if  (A.Orderdate < @CalendarDate AND (A.purchasedate > @CalendarDate OR A.purchaseDate IS NULL)) OR (A.Orderdate > @CalendarDate) then count(id) else 0   vs
Need Help
Show and Tell
Tips and Tricks
  • selpaqm's avatar
    selpaqm
    4 years ago

    refint_650  please share a table content to explain yourself well. 

    By the way you may use below schema for that kind of functions.

    and = &&

    OR =||

    Column1= IF( ( (A.orderdate < @calendardate &&
               (a.purchasedate>@calendardate || 
                a.purchasedate <> BLANK()
                )
               )
                       || a.orderdate>@calenderdate
               ),
                                count(id), 0
            )
selpaqm's avatar
selpaqm
Helper V
4 years ago

refint_650  please share a table content to explain yourself well. 

By the way you may use below schema for that kind of functions.

and = &&

OR =||

Column1= IF( ( (A.orderdate < @calendardate &&
               (a.purchasedate>@calendardate || 
                a.purchasedate <> BLANK()
                )
               )
                       || a.orderdate>@calenderdate
               ),
                                count(id), 0
            )