How to do it...

To complete this recipe, do the following:

  1. Create the following measure:
Fibonacci = 
VAR __Value = MAX('R12_Table'[Value])
VAR __Table0 =
ADDCOLUMNS(
{ 0 },
"Fib",0
)
VAR __Table1 =
ADDCOLUMNS(
{ 1 },
"Fib",1
)
VAR __Table2 =
ADDCOLUMNS(
{ 2 },
"Fib",SUMX(UNION(__Table0,__Table1),[Fib])
)
VAR __Table3 =
ADDCOLUMNS(
{ 3 },
"Fib",SUMX(UNION(__Table1,__Table2),[Fib])
)
VAR __Table4 =
ADDCOLUMNS(
{ 4 },
"Fib",SUMX(UNION(__Table2,__Table3),[Fib])
)
VAR __Table5 =
ADDCOLUMNS(
{ 5 },
"Fib",SUMX(UNION(__Table3,__Table4),[Fib])
)
VAR __Table6 =
ADDCOLUMNS(
{ 6 },
"Fib",SUMX(UNION(__Table4,__Table5),[Fib])
)
VAR __Table =
UNION(
__Table0,__Table1,__Table2,__Table3,__Table4,__Table5,__Table6
)
RETURN
SUMX(FILTER(__Table,[Value]=__Value),[Fib])
  1. On a Report page, create a Table visualization and place the Value column from the R12_Table table into the Values area of the visualization. Set the aggregation for Value to Don't summarize.
  2. In the same Table visualization, place the Fibonacci measure into the Values area of the visualization.