Forum Discussion

agatan's avatar
agatan
Frequent Visitor
7 years ago
Solved

Conditional Statments

Hi All,   I have tried to find solution to this problem for last few days with no success. I managed to get TodaysDate - 3 days using Today()-3 also I was able to extrct Name of the Day by using ...
Need Help
Show and Tell
  • ChrisMendoza's avatar
    ChrisMendoza
    7 years ago

    agatan -

     

    I think I understand your issue, possibly below will aid in your solution.

     

    ReAssigned Dates =
IF (
    WEEKDAY (
        Table1[Dates],
        2
    ) = 6,
    Table1[Dates] - 1,
    IF (
        WEEKDAY (
            Table1[Dates],
            2
        ) = 7,
        Table1[Dates] - 2,
        Table1[Dates]
    )
)
  • agatan's avatar
    agatan
    7 years ago

    ChrisMendoza 

    Hi,

    After your reasurment that the IF statment should work, I want to see what can cause the error.

    There was few oter small issues but it is working now.

    Big Thank You for your support!

     

    Kind Regards,

     

    Agata

ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
7 years ago

agatan -

 

I think I understand your issue, possibly below will aid in your solution.

 

ReAssigned Dates =
IF (
    WEEKDAY (
        Table1[Dates],
        2
    ) = 6,
    Table1[Dates] - 1,
    IF (
        WEEKDAY (
            Table1[Dates],
            2
        ) = 7,
        Table1[Dates] - 2,
        Table1[Dates]
    )
)
agatan's avatar
agatan
Frequent Visitor
7 years ago

ChrisMendoza 

 

Hi ,

Thank You for your help.

Thanks to your code I was able to reassign dated (exclude Saturdays and Sundays)!  Great help.

 

But I am still struggling to compare those two dates.

I want to find out if my  "LAST JOB START DATE " is earlier then "Reassigned Date " .

How to commpare dates ? Statments like  below dont work

IF(Table1[Last Job Start Date] > Table1[ReassignedDate], "Compliant", "Non-Compliant" )

 

Any suggestions will be highly appriciated :)

 

Kind Regards,

 

Agata

  • ChrisMendoza's avatar
    ChrisMendoza
    Resident Rockstar
    7 years ago

    agatan -

     

    Are you getting some sort of error message? An IF ( ) like what you've mentioned should work as a calculated column.

    • agatan's avatar
      agatan
      Frequent Visitor
      7 years ago

      ChrisMendoza 

      Hi,

      After your reasurment that the IF statment should work, I want to see what can cause the error.

      There was few oter small issues but it is working now.

      Big Thank You for your support!

       

      Kind Regards,

       

      Agata