Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Im not sure if i got this correct.
You want the differences between revenues from each quarter of this year and last years?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |