Forum Discussion
12 month sum indicator
Hi,
let assume we have data like this :
| Date | Sales |
| 01.01.2017 | -30 |
| 01.02.2017 | 94 |
| 01.03.2017 | 63 |
| 01.04.2017 | 90 |
| 01.05.2017 | 50 |
| 01.06.2017 | -14 |
| 01.07.2017 | 46 |
| 01.08.2017 | -51 |
| 01.09.2017 | -76 |
| 01.10.2017 | 65 |
| 01.11.2017 | -14 |
| 01.12.2017 | -65 |
| 01.01.2018 | 53 |
| 01.02.2018 | -34 |
| 01.03.2018 | 86 |
| 01.04.2018 | -51 |
| 01.05.2018 | 26 |
| 01.06.2018 | -25 |
| 01.07.2018 | 85 |
| 01.08.2018 | -24 |
| 01.09.2018 | 71 |
| 01.10.2018 | -10 |
| 01.11.2018 | 10 |
| 01.12.2018 | -70 |
I would like to create measure that will be working as 12 months sum but only in 12 months period of time : time <= maxdate, time >= maxdate - 12.
I have created a measue like this :
I would like to get a view like this ( alwyays for last 12 months ) and count how many of values per month was negative.
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
1 Reply
- Greg_DecklerCommunity Champion
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008