Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditional columns

I have a report im working on and the user wants me to add a contional column that places OVERDUE for any date that isnt the current date.  I was able to create the coulmn, but I was only able to ent...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Create a custom column in Power Query like below.

    if [date]<=Date.From(DateTime.LocalNow()) then "due" else ""

     

    When you refresh the dataset, the column will be changed.

     

    Best Regards,

    Jay

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Are you trying to have a calculated column based on the slicer. That is not possible. You can have a measure.