Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Calculated Row in Matrix

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

Sayali_25_0-1649330651819.png

Sayali_25_1-1649330746730.png

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 

4 REPLIES 4
Anonymous
Not applicable

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
Not applicable

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

Sayali_25_0-1650345190458.png

 

Anonymous
Not applicable

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

AlexisOlson
Super User
Super User

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.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors