Forum Discussion

ZachUnger's avatar
ZachUnger
Helper II
1 year ago
Solved

Overdue based on multiple Columns

Hi Team  I'm trying to create a calculated column based on the below logic and wondering if anyone can help?  The new Column will be the overdue in yellow.    Any help is appreciated.  Che...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • Irwan's avatar
    Irwan
    1 year ago

    hello ZachUnger 

     

    as far as i know, SWITCH() works similarly like IF(), so it will process the first line then second line and so on.

     

    that happens because you have date info sent value less than today (initially this what i thought but looks like you want to have "No" if there is value in date info sent not matter what the value is).

     

    Try removing this line or line 5 in your DAX, it should fix the issue.

    Overdue =
    SWITCH(
        TRUE(),
        'Table'[Date info sent]<>BLANK()&&'Table'[Date info sent]>TODAY(),"No",
        'Table'[Required by]>TODAY(),"No",
        'Table'[Extended to]<TODAY(),"Yes",
        'Table'[Required by]<TODAY()&&'Table'[Extended to]>TODAY(),"No",
        'Table'[Required by]<TODAY()&&'Table'[Extended to]<TODAY(),"Yes"
    )


    Hope this will help.

    Thank you.

ZachUnger's avatar
ZachUnger
Helper II
1 year ago

Thanks, Shravan133 this calculation is just showing past for everything... 

 

  • Irwan's avatar
    Irwan
    Super User
    1 year ago

    hello ZachUnger 

     

    does SWITCH plausible to be used for your goal?

    Overdue =
    SWITCH(
        TRUE(),
        'Table'[Date info sent]<>BLANK()&&'Table'[Date info sent]>TODAY(),"No",
        'Table'[Required by]>TODAY(),"No",
        'Table'[Extended to]<TODAY(),"Yes",
        'Table'[Required by]<TODAY()&&'Table'[Extended to]>TODAY(),"No",
        'Table'[Required by]<TODAY()&&'Table'[Extended to]<TODAY(),"Yes"
    )

     

    Hope this will help.

    Thank you.

    • ZachUnger's avatar
      ZachUnger
      Helper II
      1 year ago

      Hi Irwan 

      This is working except for if date info sent, if this column has a date shouldn't show as overdue. May be asking it to do too much...

       

      • Irwan's avatar
        Irwan
        Super User
        1 year ago

        hello ZachUnger 

         

        as far as i know, SWITCH() works similarly like IF(), so it will process the first line then second line and so on.

         

        that happens because you have date info sent value less than today (initially this what i thought but looks like you want to have "No" if there is value in date info sent not matter what the value is).

         

        Try removing this line or line 5 in your DAX, it should fix the issue.

        Overdue =
        SWITCH(
            TRUE(),
            'Table'[Date info sent]<>BLANK()&&'Table'[Date info sent]>TODAY(),"No",
            'Table'[Required by]>TODAY(),"No",
            'Table'[Extended to]<TODAY(),"Yes",
            'Table'[Required by]<TODAY()&&'Table'[Extended to]>TODAY(),"No",
            'Table'[Required by]<TODAY()&&'Table'[Extended to]<TODAY(),"Yes"
        )


        Hope this will help.

        Thank you.