Profitbase / PowerBI-visuals-FinancialReportingMatrix

Power BI Custom Visual for Financial Reporting
65 stars 23 forks source link

Other formula depending on Row and Column #531

Closed Thomma89 closed 7 months ago

Thomma89 commented 7 months ago

Hi Everyone,

I'm trying to write a formula for a specific row and column. I think I'm supposed to use the IF(RowHeader() == function but it doesn't seem to be working. Can anyone help me? Desired result would be the sum of Materialen, Arbeid, Onderaannemers and Overige Kosten in the Totale Kosten row for the Column Realisatie and Budget.

image

Thomma89 commented 7 months ago

Solved by hiding rows