I need to create a group, always taking a block of 3 months and adding the billing.
Nov - Out - Set = 1000
Out - Set - Ag = 5000
Set - Ag - Jul - 8000
I'm happy if someone can help me!!!
@renannog , it better to use a rolling month measure
Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-3,MONTH))
Rolling Months Formula: https://youtu.be/GS5O4G81fww
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
216 | |
53 | |
43 | |
42 | |
42 |
User | Count |
---|---|
269 | |
210 | |
73 | |
71 | |
64 |