Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
radiator
Frequent Visitor

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

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

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

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!





Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 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.