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
i have a table like bellow (the bigger one) and need to obtain a table with row monthNo and columns Sales for year1 and year0 and evolution; subtotal bellow; but only for YTD, if we have data till apr 2019 the table have to be like this
Month 2019 2018 %evolution
1
2
3
4
total total %total jan-apr
thanks,
Cosmin
Year | MonthNo | Salesman | Sales |
2019 | 1 | George | 80 |
2018 | 1 | George | 62 |
2018 | 2 | George | 74 |
2018 | 3 | George | 49 |
2018 | 4 | George | 28 |
2018 | 5 | George | 51 |
2018 | 6 | George | 73 |
2018 | 7 | George | 53 |
2018 | 8 | George | 75 |
2018 | 9 | George | 30 |
2018 | 10 | George | 98 |
2018 | 11 | George | 22 |
2018 | 12 | George | 97 |
2017 | 1 | George | 20 |
2017 | 2 | George | 42 |
2017 | 3 | George | 57 |
2017 | 4 | George | 24 |
2017 | 5 | George | 27 |
2017 | 6 | George | 41 |
2017 | 7 | George | 46 |
2017 | 8 | George | 19 |
2017 | 9 | George | 63 |
2017 | 10 | George | 28 |
2017 | 11 | George | 85 |
2017 | 12 | George | 74 |
Hi @cosminc
Do you add "Year" column in the slicer to select which years to show or only let "2018,2019" show on the visual?
In your example, Does the total under "2018" should be total values from 2018/1~2018/12 or 2018/1~2018/4?
What does "but only for YTD" mean?
Best Regards
Maggie
Hi,
these 2 graphs will be fixed - the filters will not be active on them
like a slide for a presentation with updates only when the source are changing
2018/1~2018/4
What does "but only for YTD" mean? - it means that i want to compare same period on time, not full previus year
thanks,
Cosmin
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |