MarcelBeug
9 years agoCommunity Champion
Status:
Done
Erroneous code generated for calculating Age for datetimezone data
Issue moved from the old issue site. In Power Query - Edit queries you can select a column with data type date/time/timezone and then choose for Transform - Date - Age. This will generate cod...
v-haibl-msft
9 years agoMicrosoft Employee
If we select a column with data type Date/Time/Timezone and do the transform, following error will be displayed which gives a clear explanation.
Expression.Error: We cannot apply operator - to types DateTime and DateTimeZone.
If you’d like the Power BI Team to change the generated code or disable Age calculation for Date/Time/Timezone data, please create an idea in https://ideas.powerbi.com.
Best Regards,
Herbert