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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Here you go I placed teh data in excel.  I removed a lot of the other data elements, but you can see what im trying to do. Basically the file refershes each day.  Uses a column in PBI called  FOLLOW UP DATE this houses dates of the files.  I wanted to build a conditional column to call out all  over due files...files that have dates prior to todays date each day so tomorrow anything marked 7/23 would now have the over due tag.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks this seemed to work, but 1 issue im running into is all the blanks in the query editer are coming back showing NULL, so when I refresh the data it keeps flagging those as errors.  Anything I can add in the code to make blanks blank and not say NULL?