Forum Discussion

Peejz_Jalmasco's avatar
Peejz_Jalmasco
Helper I
6 years ago
Solved

IF condition with dates

Hi!

Please help I don't know how to convert this expression to dax:

" If Amort OB is greater than equal to GL OB between the due date and the curing period then '1' else '0'."

 

 

Thanks!

Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Peejz_Jalmasco ,

    Try this:

    Measure =
IF (
    MAX ( 'Table'[Amort OB] ) >= MAX ( 'Table'[GL OB] )
        && MAX ( 'Table'[Date] ) >= ***   //due date
        && MAX ( 'Table'[Date] ) <= ***,   //curing peiod
    1,
    0
)
    Column =
IF (
    'Table'[Amort OB] >= 'Table'[GL OB]
        && 'Table'[Date] >= "due date"
        && 'Table'[Date] <= "curing peiod",
    1,
    0
)

    If there are some errors, please give me the screenshots and some sample data.

     

    Best Regards,
    Icey

     

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

1 Reply

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Peejz_Jalmasco ,

    Try this:

    Measure =
IF (
    MAX ( 'Table'[Amort OB] ) >= MAX ( 'Table'[GL OB] )
        && MAX ( 'Table'[Date] ) >= ***   //due date
        && MAX ( 'Table'[Date] ) <= ***,   //curing peiod
    1,
    0
)
    Column =
IF (
    'Table'[Amort OB] >= 'Table'[GL OB]
        && 'Table'[Date] >= "due date"
        && 'Table'[Date] <= "curing peiod",
    1,
    0
)

    If there are some errors, please give me the screenshots and some sample data.

     

    Best Regards,
    Icey

     

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