Forum Discussion

siddrow's avatar
siddrow
Icon for Helper III rankHelper III
1 year ago
Solved

Help with custom column for filtering

Hi   I've created the below custom column which I will then use to create a measure to switch the colour of the font in a visual (1 week = red, 2 weeks = orange, 1 month = red) and also use as a fi...
Need Help
  • parry2k's avatar
    parry2k
    1 year ago

    siddrow try this:

     

    if Duration.Days([Due Date]-[#"Today's Date"]) <=7 and [#"Total % Complete"] = 0 then "1 Week"
else if Duration.Days([Due Date]-[#"Today's Date"]) >7 and Duration.Days([Due Date]-[#"Today's Date"]) <=14 and [#"Total % Complete"] <0.8 then "2 Weeks"
else if Duration.Days([Due Date]-[#"Today's Date"]) >14 and Duration.Days([Due Date]-[#"Today's Date"]) <=30 and [#"Total % Complete"] <0.9 then "1 Month"
else ""
parry2k's avatar
parry2k
Icon for Super User rankSuper User
1 year ago

siddrow try this:

 

if Duration.Days([Due Date]-[#"Today's Date"]) <=7 and [#"Total % Complete"] = 0 then "1 Week"
else if Duration.Days([Due Date]-[#"Today's Date"]) >7 and Duration.Days([Due Date]-[#"Today's Date"]) <=14 and [#"Total % Complete"] <0.8 then "2 Weeks"
else if Duration.Days([Due Date]-[#"Today's Date"]) >14 and Duration.Days([Due Date]-[#"Today's Date"]) <=30 and [#"Total % Complete"] <0.9 then "1 Month"
else ""
siddrow's avatar
siddrow
Icon for Helper III rankHelper III
1 year ago

Thanks so much - this worked!