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
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

 

Highlighted
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.