Forum Discussion

BJW's avatar
BJW
Frequent Visitor
7 years ago
Solved

Using a date/time field in Power BI

I'm quite new to Power BI, but I've been trying to google a solution without success. I'm connected to a sharepoint list, and within that list there is a field called Meeting Date/time.  This fiel...
Need Help
  • Gordonlilj's avatar
    Gordonlilj
    7 years ago

    Hi,

     

    You could create a calculated column:

    Calc = if(Table[Column] < NOW(),"Completed","Scheduled")
    Or in power query add a custom column:
    if column < DateTime.LocalNow() then "Completed" else "Scheduled"
    Just change table/column to your own and it should work fine
     
Gordonlilj's avatar
Gordonlilj
Solution Sage
7 years ago

Hi,

 

You could create a calculated column:

Calc = if(Table[Column] < NOW(),"Completed","Scheduled")
Or in power query add a custom column:
if column < DateTime.LocalNow() then "Completed" else "Scheduled"
Just change table/column to your own and it should work fine
 
BJW's avatar
BJW
Frequent Visitor
7 years ago

Worked perfect, thanks.