Forum Discussion
Solved
undefined
The FORMAT function for date is returning the date on Dd-MM-YYYY instead of Month when given Column = FORMAT( CONTRACT[CONTRACT_DT,"DDDD"])
v-kpoloju-msft Thanks for checking It started working when I have given the correct the given format.Thanks FBergamaschi
The syntax you mention
Column = FORMAT( CONTRACT[CONTRACT_DT,"DDDD"])
Cannot work
In case
Column = FORMAT( CONTRACT[CONTRACT_DT],"DDDD")
But you want the month so
Column = FORMAT( CONTRACT[CONTRACT_DT,"mm"])
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI