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

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

111.PNGExample: in excel no problem222.PNGExample: in excel no problemsssss.PNGI need in this Chart

 

how to create? please help meeeee.

 

2 REPLIES 2
Highlighted
levankup777 Frequent Visitor
Frequent Visitor

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

 

DB ex.PNGmy data

 

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

 

Moderator Eric_Zhang
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)
    Capture.PNG
  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])
    Capture.PNG
  4. Drag a "Line and stacked column char" and select columns properly.
    Capture.PNG

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

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