Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello i have this
model | date | cant | modelid | ||
model1 | 01.01.2022 | 1 | mod01 | ||
model2 | 03.01.2022 | 2 | mod02 | ||
model3 | 10.01.2022 | 4 | mod03 | ||
model4 | 15.01.2022 | 2 | mod04 | ||
model5 | 17.01.2022 | 1 | mod05 | ||
model1 | 12.02.2022 | 4 | mod01 | ||
model3 | 15.02.2022 | 2 | mod03 | ||
model5 | 15.02.2022 | 5 | mod05 | ||
model1 | 19.02.2022 | 1 | mod01 | ||
model3 | 21.02.2022 | 2 | mod02 | ||
Last 30 day starting from slicer selected value of 15.02.2022 | |||||
model | Total | ||||
model1 | 4 | ||||
model2 | 0 | ||||
model3 | 2 | ||||
model4 | 2 | ||||
model5 | 6 |
i write a formula for a measure
Solved! Go to Solution.
@cristianj , Join the date of table with date of date table and try a measure like example
Rolling 30 = CALCULATE(Average(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-30,DAY))
refer, if needed
Rolling Days Formula: https://youtu.be/cJVj5nhkKBw
@cristianj , Join the date of table with date of date table and try a measure like example
Rolling 30 = CALCULATE(Average(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-30,DAY))
refer, if needed
Rolling Days Formula: https://youtu.be/cJVj5nhkKBw
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
87 | |
61 |