cancel
Showing results for
Search instead for
Did you mean:
Frequent Visitor

## I need Percent difference of previous year, quarter, month. please help meeeee

Example: in excel no problemExample: in excel no problemI need in this Chart

how to create? please help meeeee.

2 REPLIES 2
Highlighted
Frequent Visitor

## Re: I need Percent difference of previous year, quarter, month. please help meeeee

my data

This is my data. Please help me with this data. Thank you in advance

Moderator

## Re: I need Percent difference of previous year, quarter, month. please help meeeee

@levankup777
That picture doesn't help much. We have no way to copy your sample data from a picture.

To get the expected output, please reference the below steps against simple sample data.

1. Supposing the sample data has two columns(DT,QTY) as below. Create a new column Month.
`Month = DATE(YEAR('Table'[DT]),MONTH('Table'[DT]),1)`
2. Create a new table 2015dataAgg
`2015dataAgg = SUMMARIZE(FILTER('Table',YEAR('Table'[DT])=2015),'Table'[Month],"GrpByMonValue",SUM('Table'[QTY]))`
3. Create 3 columns
```LastMonth = DATEADD('2015dataAgg'[Month],-1,MONTH)
LastMonthVal = CALCULATE(SUM('2015dataAgg'[GrpByMonValue]),FILTER('2015dataAgg','2015dataAgg'[Month]=EARLIER('2015dataAgg'[LastMonth])))
Difference = IF(ISBLANK('2015dataAgg'[LastMonthVal]),BLANK(),('2015dataAgg'[GrpByMonValue]-'2015dataAgg'[LastMonthVal])/'2015dataAgg'[GrpByMonValue])```
4. Drag a "Line and stacked column char" and select columns properly.

In case for any confusion, I've uploaded the pbix.

If you have any question, feel free to let me know.