Forum Discussion

Summer_PBI's avatar
Summer_PBI
New Member
3 years ago

Indexing Data :)

Hello, I would please like some help to create an index table. I have a 'date' table to which 'my data' table is joined to by 'date'. - format e.g 01/04/2021    Suppose I have a created a pivot  ...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Summer_PBI Try:

Measure Ratio =
  VAR __Value = [Measure] //whatever you currently have in your matrix
  VAR __Average =
    AVERAGEX(
      ADDCOLUMNS(
        SUMMARIZE(ALLEXEPT('Table',[Year]),[Month]),
        "__Value",[Measure]
      ),
      [__Value]
    )
  VAR __Result = DIVIDE(__Value, __Average)
RETURN
  __Result