Forum Discussion

rezaaditia's avatar
rezaaditia
Helper III
7 years ago
Solved

expression that yield variant data-type cannot be used to define calculated columns

Hi -   Please help, i am stuck with this formula, had searched over the internet, but no luck i want to create TAT column using Dax formula with adding new column,   TAT = IF ( ISBLANK ([po...
Need Help
Show and Tell
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    rezaaditia 

     

    Append the following text to the end of your formula.

    & ""
amitchandak's avatar
amitchandak
Super User
7 years ago

Here we are comparing text format year with numeric format year

CALCULATE(sum(Sales[Sales]),OrderTime[Order Year]= CONCATENATE( Year(NOW())-2,""))
rezaaditia's avatar
rezaaditia
Helper III
7 years ago

Hi amitchandak 

 

I did try but still got same error.

 

Thanks

  • amitchandak's avatar
    amitchandak
    Super User
    7 years ago

    Share new calculation