Forum Discussion

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi juanmobando,

 

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

 

Best Regards!
Dale

juanmobando's avatar
juanmobando
Frequent Visitor
8 years ago

Hi Dale,

 

Thanks for the help.

 

But I am afraid I cannot even create the first calculatio for the year 2014

 

 

CALCULATE ( SUM ( Table1[Sales] ), Table1[Year] = 2014 )

When I am creating the measure, I can only get to the first expression, but Bi does not allow me to enter the  Table1[Year] expression... 

 

Therefore I cannot go any forward with the solution.

 

Is there something I need to enable on the formulae or any options that I am not looking at that would be helpful? I am afraid that there is might be an issue of the syntax, because I tried but it does not allow me enter other field on the expression..

 

Please let me know.

 

Thank you!