Forum Discussion
DAX Measure If Row header is then
Hi, I have a matrix table where there are 4 row headers for a P&L report. I've been looking for a measure where it would calculate "Global Var% of LY" based on the table maxtrix row name. The c...
VijayP
Community Champion
Community Champion"[Global Total Value TY]-[Global Total Value LY])/[Global Total Value TY] otherwise for COST OF SALES, DIRECT EXPENSES AND OVERHEADS return [Global Total Value LY]-[Global Total Value TY])/[Global Total Value LY]."
The above statemet is bit confusing. just rephrase it so that I can help. I work PNL in Power bI
Apologise if this wasn't clear, I have amended my post.
- az38
how should look like value in row TOTAL NEW SALES - Sales?
