Forum Discussion

cchen75's avatar
cchen75
Frequent Visitor
1 year ago
Solved

Convert DateTime to Table is Missing

I am trying to create a date table in Power Query. I create this by opening a blank query then use DateTime.LocalNow( ) and normally, there is an option to convert to table but it is not showin...
  • Mubar's avatar
    1 year ago

    Hi cchen75 

     

    This is a Power Query issue I've noticed lately, you can convert it to a list by doing so in your M code. then right-click and convert to a table.

    = {DateTime.LocalNow()}

     

    If you find this helpful, kindly mark my response as a solution.

     

    Thanks, Happy Building

    Mubar