Forum Discussion

New_be's avatar
New_be
Helper V
5 years ago
Solved

Group By: Not Working

Hi expert! I have one problem that i think people from this community can help me with ğŸ˜Š   Problem: I want to group a value column based on certain columns. But when I use function grouped by, it...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    New_be , I doubt your date has timestamp

     

    Create a date from production date in power query and try with that date

    DateTime.Date([production_date])

amitchandak's avatar
amitchandak
Super User
5 years ago

New_be , I doubt your date has timestamp

 

Create a date from production date in power query and try with that date

DateTime.Date([production_date])

  • New_be's avatar
    New_be
    Helper V
    5 years ago

    Thanks amitchandak ! ğŸ˜ƒ Its work like you said. But i don't know why it is not working for me before as i already converted the datatype.