Forum Discussion

amartinez246's avatar
amartinez246
New Member
7 years ago

Data Short

I have an excel which i am sourcing the data from, this includes invoice dates back for 2005, I have created a date table to group sales by year but visually I have not been able to short so that whe...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi amartinez246 ,

I’m a little confused for your requirement. Do you want to compare the total sales between 2018 and 2019 ?  I create a sample for calculating subtraction of total sales between two years.

 

I have two tables. The “Table” is a calendar table. The columns of A and B in Table1 are the different category of products. There  is a many-to-one relationship between two tables. And I just calculate the sales of A. B is the same as A.

total = SUM(Table1[A])

2018 A = CALCULATE(SUM(Table1[A]),DATEADD('Table'[Date].[Date],-1,year))

2018-2019 = IF( ISBLANK([2018 A]),BLANK(),[2018 A] -[total] )

If I understand incorrectly, please post some sample data.

 

Best Regards,

Xue Ding

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.