Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there!
Hopefully you guys can help me out. I have the following situation:
I want to select a given period of time (let's say 1-jan-2018 | 15 mrt-2018 and I'd like to compare that selection automatically with SPLY. It should be visualized as follows:
Year | Year to 15 Mar | Rest of Year | Total Year |
2015 | 2 | 10 | 12 |
2016 | 1.5 | 12 | 13.5 |
2017 | 4 | 13 | 17 |
2018 | 1 | 16 | 17 |
2019 | 3.0 |
This should be a stacked column with 'selection' + 'rest of year' in the column
Hi @johanthedataman,
What is the source dataset? What value do you want to compare between current year and last year? Are [Year to 15 Mar], [Rest of Year] and [Total Year] original columns in source table or calculated columns/measures? Please provide more description about your requirement. How to Get Your Question Answered Quickly
Regards,
Yuliana Gu
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |