Forum Discussion
Create a custom column that tracks if date is less than current day
Hi Anonymous,
this is just an example to give you a taste of the possible solution. For your code you need to adopt the Added Custom step. In your case if would look something like:
#"Added Custom" = Table.AddColumn(#"Changed Type", "Status", each if [closing date] < Date.From(DateTime.FixedLocalNow()) then "Expired" else "Active", type text)If you are using a standard Add Column button in the main menu, this is the code that you need to paste into the dialog box:
if [closing date] < Date.From(DateTime.FixedLocalNow()) then "Expired" else "Active"
Cheers,
John
Memorable MemberHi Anonymous,
Something like this?
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQ3NNQ3MlKK1YlWMkJiGyOxTZDYpiC2sbFSbCwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Status", each if [Date] < Date.From(DateTime.FixedLocalNow()) then "Expired" else "Active", type text)
in
#"Added Custom"Cheers,
John
Hi jbwtp
I'm a bit confused with this one, I've added it in, but it looks like it's just generated it's own date column. I want it to use my date column which is "closing date" and check if that's less than todays date.
- jbwtp
Hi Anonymous,
this is just an example to give you a taste of the possible solution. For your code you need to adopt the Added Custom step. In your case if would look something like:
#"Added Custom" = Table.AddColumn(#"Changed Type", "Status", each if [closing date] < Date.From(DateTime.FixedLocalNow()) then "Expired" else "Active", type text)If you are using a standard Add Column button in the main menu, this is the code that you need to paste into the dialog box:
if [closing date] < Date.From(DateTime.FixedLocalNow()) then "Expired" else "Active"
Cheers,
John
Thank you jbwtp the custom column worked!