Solved: Combining Dates

hspenik3 · ‎12-29-2020

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?

aj1973 · ‎12-29-2020

Hi @hspenik3

Use Matrix and put the dates in the Column

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

Anonymous · ‎12-30-2020

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

amitchandak · ‎12-29-2020

@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]))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube