Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Currently we have a metric called "PM" which is "Prior Month". When a user selects 2 months, PM reflects the first month and the month before. For example, selecting March + April, will cause PM on the metric card to reflect data for February + March. But i need January + February. Same when i select 3 months it should show previous 3 months dats.
Hi @Anonymous
Do you mean if you select
1. Mar, then return Feb ?
2. Mar + Apr, then return Jan + Feb ?
3. Mar + Apr+ May, then return Last Dec + Jan + Feb ?
Please kindly share your dummy pbix or simple worksheet that would be easier for us to provide the valuable advice.
Are these months are continuous, or they can be discrete too?
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |