Measure calculated for rolling specified period
Hello, i calculate Demand Plan Monthly Error as a measure DPME = |Demand Plan - Actual Sales| / Actual Sales The result looks similar like that: i also give informaction how DPME look for last 12 month altogether. In showed example is 77% (ist not average, DPME is calculated for last 12 mc altogether). I have to prepare a chart as above but instead of showing for yyyy-mm data for a given month, I have to show, data for the last 12 months. Example: For data prepared in Sep-24 in 2024.8 need to show DPME for period from 2024.8 to 2023.9 (for 12 months, but calculated from the month that was 1 months ago) in 2024.7 need to show DPME for period from 2024.7 to 2023.8 (for 12 months, but calculated from the month that was 2 months ago) in 2024.6 need to show DPME for period from 2024.6 to 2023.7 (for 12 months, but calculated from the month that was 3 months ago) (......) in 2023.9 need to show DPME for period from 2024.9 to 2022.10 (for 12 months, but calculated from the month that was 12 months ago) is it posiible to do some measures like that? which can be put on chart on the top?
Evolution rate only for common months
Hello guys, I'm trying to display an evolution rate which compares datas over 2 years. BUT, I only want common months to be part of the calculation. (In 2022, I have datas for 6 months, and in 20221 I have datas for 5 months). I just want my measure to calculate the rate between the 5 common months. Here is an extract of my data. And here is my DAX measure : Rate N /N-1 = divide ( sum('file'[Data N])-sum('file'[Data N-1]),sum('file'[Data N-1]),"NA") Of course, I want to be able do display my charts for each year, using a slicer for years. Can someone give me the solution please ? I'm sure it's not that difficult ! Thans a lot !
Events for a Period time
Hello I'm begings to use Power BI and I'm interesting to know if someone can help. Problem: How to measure the correct Duration by Hour? If I sum the column"Hour" I get a wrong value of 143 instead of 104.18 as table below. My doubt is I need to duplicate the rows breakdown the times or it's possible a metric to analize the data. Start End Duration (sec) hour 2022-09-09T07:58:15.753 2022-09-09T07:58:21.820 6 7 2022-09-09T07:58:21.820 2022-09-09T08:00:38.357 137 7 2022-09-09T08:00:38.357 2022-09-09T08:04:48.450 250 8 Hour SUM_Duration by hour Sum_Duration by period 7 143 104.18 8 250 288.82
