Forum Discussion

TimmK's avatar
TimmK
Helper IV
4 years ago

Profitbase Income Statement Percentage

I use the visual "Financial Reporting Matrix by Profitbase" to create an income statement with custom rows. The measures I use are Amount and %. The % is the amount of the specific year compared to t...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI TimmK,

You can try to use the following measure formula if helps:

% =
VAR currDate =
    MAX ( 'Date'[Date] )
RETURN
    DIVIDE (
        CALCULATE (
            [Sales],
            FILTER ( ALLSELECTED ( Table ), 'Table'[Year] = YEAR ( currDate ) )
        ),
        [Sales],
        0
    ) - 1

If that also doesn't help, can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng