Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi I have table with columns date( Datetime or date or months) , price(number) , company(string).
I would like to create visual with 4 columns Company name, Total price period 1, Total price period 2 , Total price period 2 / Total price period 1
I want to determine period 1 , period 2 by slicers that depend on column date at the same time.
Do you have any idea? Visual level slicers are useless because period 1 is not period 2. Measure , I am not sure that it will be dynamic . I mean user who will use visual , he will determine period, not by creating measure with fixed periodes.
Fo example - Q1 2017 vs q1 2018 , January 2018 vs February 2018. Q2 2018 vs Q3 2018 etc
You can use the method presented in this article:
https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/
It relies on having a Date table and a 'Previous Date' table (with an inactive relationship).
Have a look at that and please post back if you need further assistance applying it in your model.
Regards,
Owen
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |