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
            )

1 Reply

  • 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
            )