I have a new Measure, myNewMeasure, which will be based on two other Measures. PowerPivot is giving me this error:
Semantic Error: Failed to resolve name 'MyRatio'. It is not a valid table or function name.
MyRatio_ThisYear:=(sumA+SumB)/sumC <-- works.
MyRatio_LastYear:=((sumA+SumB)/sumC , dateadd('Date'[datekey], -1, year)) <-- works.
MyNewMeasure:=(MyRatio_ThisYear/MyRatio_LastYear) <-- Semantic Error: Failed to resolve name 'MyRatio'. It is not a valid table or function name.
How to create a new measure based on measures within PowerPivot?
-- IBM has jobs for USA employee to work oversea (India) and get their wages.
Can you try putting bracket delimiters around the first and second measures you are using to define the third?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?