Reply
radiator
Frequent Visitor
Partially syndicated - Outbound

Datediff - many wrong results

Hi all,

 

I discovered there were issues with my datediff. It works and then it doesn't. When looking at a time period it looks like it starts not working when we are entering a new month. It works when the line is flat. Any idea what the issue here is?

radiator_0-1737062947018.png

 

Best regards,

 

radiator

 

1 ACCEPTED SOLUTION
radiator
Frequent Visitor

Syndicated - Outbound

Nevermind, the stoptime column had turned into text after doing some query changes. Back to datetime and everything works fine.

View solution in original post

2 REPLIES 2
radiator
Frequent Visitor

Syndicated - Outbound

Nevermind, the stoptime column had turned into text after doing some query changes. Back to datetime and everything works fine.

ToddChitt
Super User
Super User

Syndicated - Outbound

We will need to see the DAX or M code that you have in place, along with some sample data.

Also, what do you HOPE to have as an expected output.

Help us help you. 




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)