Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm creating a report in which the first half of the fiscal year requires the application of a fixed rate from Q3-Q4 of the previous year and then the second half of the year uses the Q1-Q2 fixed rate of the current year. All my attempts at measure creation never applies to the correct month. Is there a way to perform this?
This crude table likely does a much better job at explaining. Example for this month (November) I need to apply a static rate from April 2018 - September 2018. Any help would be greatly appreciated!!
Hi @Anonymous,
Is this image you post your data sample or the desired output?
If it is convenient, could you share some data sample and your desired output so that we can help further on it.
Best Regards,
Cherry
@v-piga-msft that image is just a diagram of the relationship.
My desired output and sample data are below. I'm trying to calculate the applied rate which is the average of the previous two quarters.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |