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