Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
NL-Nicolas
Helper I
Helper I

Dax Bug or Code Error?

‎08-29-2022 05:29 AM

Hey Community, I have a weird one here where my data column is doing a Last week vs a Week 1 year ago and for some reason most of the math is right but some years think they are in the 2100s+ for some odd reason. Here is a screenshot anything obvious I missed?

NLNicolas_0-1661776168751.png

 

Labels:
Message 1 of 5
573 Views
0
1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

‎08-29-2022 05:47 AM

Hi @NL-Nicolas 

your column DF_BusinessDay is text format. You need to fix that in power query and assign date data type to this column. 

View solution in original post

Message 2 of 5
537 Views
0
4 REPLIES 4
tamerj1
Super User
Super User

‎08-29-2022 05:47 AM

Hi @NL-Nicolas 

your column DF_BusinessDay is text format. You need to fix that in power query and assign date data type to this column. 

Message 2 of 5
538 Views
0
NL-Nicolas
Helper I
Helper I
In response to tamerj1

‎08-29-2022 06:05 AM

So I tried fixing that inquery howevery it was already set to Date Time, I set it to just date and still same result... Gonna keep looking in the Query Editor I think you are on the right track

Message 3 of 5
528 Views
0
AnkitKukreja
Super User
Super User
In response to NL-Nicolas

‎08-29-2022 06:12 AM

Hi! @NL-Nicolas 

 

Is it possible to share the sample pbix to have a look at it?

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
Message 4 of 5
524 Views
0
NL-Nicolas
Helper I
Helper I
In response to AnkitKukreja

‎08-29-2022 09:06 AM

I cant in this regard due to the client but if there is anything you need to see I can share some Screenshots

 

Message 5 of 5
513 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All