I have different fields all associated with the same date but for some reason I'm getting multiple lines instead of just showing it under one single day. How can I fix this?

Hi hspenik3 Use Matrix and put the dates in the Column

Combining Dates | Microsoft Fabric Community

aj1973
Community Champion
5 years ago
Hi hspenik3
Use Matrix and put the dates in the Column
amitchandak
Super User
5 years ago
hspenik3 , I think your date has a time stamp, and you are not able to see it because of the format.

Change the data type to date/time and choose a format that can show you time

and get a date column like

new Date = [Date].date
or
new Date = date(year([Date]),month([Date]),day([Date]))
Anonymous
Not applicable
5 years ago
HI hspenik3,

Can please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng