Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
161
Views
Topic starter
Hi guys!
I am just new here and I am still quite woody in using powerquery out of the tutorial examples. I am starting maybe with a trivial question.
I need to transform a Date filled column (formatted Date Only) to Logic Value Column in terms of zeros (where origin column has a null) and ones (where origin column has a date). My task in my small exercise is then to count with group function.
Thanks,
Alberto
Posted : 12/05/2020 9:22 am
Hi Alberto,
You can add a Conditional Column and specify 0 for null and 1 for not null:
https://www.myonlinetraininghub.com/power-query-if-statements
then delete the date column.
Regards
Phil
Posted : 12/05/2020 9:14 pm
