To complete this recipe, do the following:
- 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])
- 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.
- In the same Table visualization, place the Fibonacci measure into the Values area of the visualization.