How can we extract MM/DD from date format yyyy/mm/dd in direct query mode.
Go to Solution.
You can write a measure to format date value to mm/dd:
Date(MM dd) = FORMAT(MAX(DateVal[Value]),"mm/dd")
View solution in original post
how can we use / symbol in a formulae so that output format can look like 11/12.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!