Hi All,
I have imported data into power query and i want to add custom column which states the latest date in the same table (I will then use this in a subsequent formula). However, I can't for the life of me work out how to do it. I am trying to use "List.Max" but the column just returns errors.
Not sure how, but I managed to create a query which returns the correct value but I don't know how to reference the value in the subsequent formula. Any help would be greatly appreciated! Thanks,
Dan
I have imported data into power query and i want to add custom column which states the latest date in the same table (I will then use this in a subsequent formula). However, I can't for the life of me work out how to do it. I am trying to use "List.Max" but the column just returns errors.
Not sure how, but I managed to create a query which returns the correct value but I don't know how to reference the value in the subsequent formula. Any help would be greatly appreciated! Thanks,
Dan