none
How to create a new measure based on measures within PowerPivot

    Question

  • 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.

    Monday, September 16, 2013 4:50 PM

Answers