In a matrix visual, we group rows per Office, then User. On each user row, we display a dozen of different measures (ex: Sales $, Count of Projects Won, Count of Project Lost, ...).
We have a slicer on the fiscal period (month).
The user want to have the exact same measures, for last 3 months, last 6 months, and last 12 months.
I am very new to power bi and my first idea is to duplicate all measures to have a set for current period, another set for last 3 months, etc...
This seems quite easy to do, but a nightmare to maintain, as measures contains some logic.
Is there some way to adapt my current measures with some kind of parameters, which would allow me to re-use the same measure in the context on last 3 monts, last 6 months, ...
So the user would slice on, for example, period 2019-06, then would see this period values, last 3 month values, ..., all at the same time.
Any help appreciated, thanks!
