Dear all,
I am trying to figure out a DAX formula that will "digest" non consecutive dates
I have a model of different budget releases which are issued at the beginning of each month based on supply chain revision
I have indexed the budget release of each month with a date using a format as follow : 01/01/2017 etc...
Each plan is a subset of 12 months rolling and I want to compare per month the variance between one release to the other @ months level
In have a budget measure done for which I would like to calculate the following:
- Measure 1 = Sum budget
- Measure 2 = calculate(Measure1,filter(Forecast release = forecast release month -1) ie compare this month vs previous one
- Measure 3 = Measure 1 - Measure 2
I tried as well to make a filter of the form Forecast release = last month release, but still to no avail....
Ideally, measure 3 should give me a delta for a given month of release by planned month
Any ideas are welcome
Thanks a lot
I am trying to figure out a DAX formula that will "digest" non consecutive dates
I have a model of different budget releases which are issued at the beginning of each month based on supply chain revision
I have indexed the budget release of each month with a date using a format as follow : 01/01/2017 etc...
Each plan is a subset of 12 months rolling and I want to compare per month the variance between one release to the other @ months level
In have a budget measure done for which I would like to calculate the following:
- Measure 1 = Sum budget
- Measure 2 = calculate(Measure1,filter(Forecast release = forecast release month -1) ie compare this month vs previous one
- Measure 3 = Measure 1 - Measure 2
I tried as well to make a filter of the form Forecast release = last month release, but still to no avail....
Ideally, measure 3 should give me a delta for a given month of release by planned month
Any ideas are welcome
Thanks a lot
Last edited: