The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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
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
I(WE?) don't have access to your sharepoint
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.