Is it possible to create a whole new table where every cell has a different DAX formula that has to be evaluated? Because right now this is not happening as the formula I type in is read as text.
I want a table like this:
Last week revenue formula to calculate the same
Revenue for item 1 formula to calculate the same(different from the one above)
Revenue for item 2 formula to calculate the same
I need to turn this into a waterfall chart.
Basically I need the first row as the starting value.