This is because "right" is an Excel formula
You can try the following:
Year = Date.Year([Date])
Your Date column must have the data type of Date
i use the split column function to get the Year, month and day.
i try to create a new date by using
date= datevalue(CONCATENATE((CONCATENATE([Month],[Day])),[Year])) from create Add Custom Column.
It returned error:
Expression.Error: The name 'datevalue' wasn't recognized. Make sure it's spelled correctly.
This code should work below.
=[#"Day"] & "/" & [#"Month"] & "/" & [#"Year"]
Then once you have that column created, convert the data type to Date
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.