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 !
