Forum Discussion

TimmK's avatar
TimmK
Icon for Helper IV rankHelper 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...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

TimmK , Can you share % formula


Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • TimmK's avatar
    TimmK
    Icon for Helper IV rankHelper IV
    4 years ago

    Yes, here is the % measure:

    % =
    DIVIDE(
       CALCULATE(
          [Sales],
          ALL('Date'[Date].[Year]),
          'Date'[Year]=YEAR(TODAY())
       ),
       [Sales],
       0

    )

    -1