Forum Discussion

AlexGallet01's avatar
AlexGallet01
Helper IV
9 years ago

I need help

Mesure 2015-2016 = CALCULATE(SUM(Factures[2015-2016]);FILTER(ALL(Factures);Factures[Mois.Date] >= DATE(2015;07;01) && Factures[Mois.Date] <= MAX(Factures[Mois.Date])))   Bonjour, J'aimerais rempla...
Need Help
AlexGallet01's avatar
AlexGallet01
Helper IV
9 years ago

Hi 

 

I have a problem when i want create a column fiscal year i have an error ( Expressions that return a variant data type can not be used to define computed columns.)

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago
AlexGallet01 wrote:

Hi 

 

I have a problem when i want create a column fiscal year i have an error ( Expressions that return a variant data type can not be used to define computed columns.)

 

Did you try to create a calculated column like this?

Fiscal Year = IF ( MONTH ( 'Calendar'[Date] ) <= 6, 'Calendar'[Year], 'Calendar'[Year] + 1 )

 

Please check if the 'Calendar'[Year] data type is number rather than text. If issue persists, please share your .pbix file if possible.

 

Best Regards,
Qiuyun Yu