Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 field contains both date and time (formatted correctly by sharepoint list column).
I want another column in my query which looks at this date/time like this..
If meeting is less than now, then "Completed", else "Scheduled"
I've no idea how to set a new column as this in PowerBI, so some idiot guide is much appreciated.
thanks.
Solved! Go to Solution.
Hi,
You could create a calculated column:
Calc = if(Table[Column] < NOW(),"Completed","Scheduled")
if column < DateTime.LocalNow() then "Completed" else "Scheduled"
Hi,
You could create a calculated column:
Calc = if(Table[Column] < NOW(),"Completed","Scheduled")
if column < DateTime.LocalNow() then "Completed" else "Scheduled"
Worked perfect, thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |