Forum Discussion

jhd's avatar
jhd
Icon for Helper I rankHelper I
8 years ago

Fiscal Year Total

Below is a "simple" version of my data table:    Date Month Product Sales_Value Financial_Year FY_Sales_Value 01/02/2018 Feb A 500 2017 1100 02/02/2018 Feb A 600 2017 1100 ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi jhd,

 

In Power BI desktop, after adding calculated column [FY_Sales_Value] into a table visual, to avoid it to be multiplied by the number of lines in the table per month, you can select "Don't summarize".

 

However, if you have any concern about using PowerPivot, I would suggest you post question on a more related forum.

 

Best regards,

Yuliana Gu