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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
cristianj
Helper IV
Helper IV

I think there is an error with this formula weekday

cristianj_0-1671709178702.png

 

Zi Luna Zi Sapt = day(buy_phone_details[CreatedAtRo])&"."&month(buy_phone_details[CreatedAtRo])&" - "&switch(weekday(buy_phone_details[CreatedAtRo]),2,"Luni",1,"Duminica",3,"Marti",4,"Miercuri",5,"Joi",6,"Vineri",7,"Sambata"), if the hour of the date is 23.59.59, the datediff says that the day number is in the next day
Anyone has this problem?
Thank you

 

2 REPLIES 2
amitchandak
Super User
Super User

@cristianj , You can get weekday names like

 

format([Date], "dddd")

 

you can use locale_name

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

yes, i get the number of weekdate, from plain date, whithout hour and minute, but i thought it was a mistake

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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