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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
sandee
Helper I
Helper I

ISO Date Function

Hello Everyone,

 

please could you help me, as i am preparing a new power Bi model where i am creating a calender table.

 

in that i have to mention "ISO date" COLUMN, please can you advise or show , i mean what is the calculation to get the ISO date , i thought this will not be a challenge but it is a tricky one.

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@sandee Do you like this in DAX?

Column = FORMAT([Column1],"yyyy-mm-dd")


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

@sandee Do you like this in DAX?

Column = FORMAT([Column1],"yyyy-mm-dd")


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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