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

Pragati11's avatar
Pragati11
Super User
6 years ago

HI Anonymous ,

 

I understand very little of what you are trying to achieve.

Can you share some sample data or screesnhots to understand your issue easily?

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have files coming in to my report daily, for each file that is not the current date needs to be marked overdue.  Basically anything that is not the current date would be over due.  So today anything 7/22 and prior is over due then tomorrow anyhting 7/23 prior would be flagged and so on.