Forum Discussion

harikodali03's avatar
harikodali03
Frequent Visitor
8 years ago

Compare current 4 quartets with previous 4 quarters.

Hi All,

 

Need help on below issue.

 

My Data Set :

 

revenue     period     --- Both are text fields.

 

100         2018Q1

200         2018Q1

100         2017Q4

200         2017Q4

100         2017Q3

200         2017Q2

100         2017Q1

200         2016Q4

100         2016Q4

200         2016Q4

100         2016Q3

200         2016Q3

100         2016Q2

200         2016Q2

100         2016Q1

200         2016Q1

 

 

My Comparaison is    sum ( 2018Q1, 2017Q4,2017Q3,2017Q2)   with Sum( 2017Q1,2016Q4,2016Q3,2016Q2)

 

Is it posiable in power BI ?

2 Replies

  • az2451's avatar
    az2451
    Resolver I
    8 years ago

    Im not sure if i got this correct.

     

    You want the differences between revenues from each quarter of this year and last years?

     

    • harikodali03's avatar
      harikodali03
      Frequent Visitor
      8 years ago

      we are planned to compare last 12 months( sum) data with previous 12 month (sum)data,This process we need to automate. If any new data set is refreshed then we need start comparision current 12 month sum with previous 12 months sum.