Calculated Row in Matrix

[Anonymous]

I'm having a hard time figuring this out.

I'm building a financial report,nd I'd like to include a calculated row (not a column).The table looks like this

the query i am creating in dax is creating new column,but i want to insert row in same column with the above formula in power bi.

I have differnt calculations for different rows =IF(C6=0,"- ",(C6+C7)/C8)

=IF(C4=0,"- ",(C5+C6)/C7)

Please help with this calculations ..........output  as = calculated row added in same column 

[Anonymous]

the recursive formula you require, by itself, is doable in power query. For the rest it depends on the context in which you have to apply it.
It is not clear which table you start from,
it is not clear how and where to apply the formula;
the result you are looking for is not clear (how many lines do you need to add, for example?);
if you explain with more precision and completeness you may have more satisfactory answers.

let
    source = {13,14,15,16},
    newel=List.Accumulate({0..10}, source, (s,c)=> if s{c}=0 then "-" else s&{(s{c}+s{c+1})/s{c+2}}),
    out=source&newel
in
    out

[Anonymous]

Thanks for the solution,i am able to add inforiver Could you help me with DAX calculation   FOR =IF(C11=0,"- ",(C21+C26)/C11) CONDITION,this is an excel calculation i want same calculation in DAX,

 Power BI

[Anonymous]

I(WE?) don't have access to your sharepoint

[AlexisOlson]

This is pretty difficult to do (though not impossible) in Power BI as it's not designed for this sort of thing.

If this is something you plan to do often, then I'd recommend trying out Inforiver inside of Power BI or a different tool entirely like Power BI Report Builder to make a paginated report.