Setup PLAN values based on values from 1st month
Dear community, As I am new with PBI I am currently struggling over a simple issue which I can not solve on my own. I should appreciate your support. Here we go: I have several reports which I load into Dataset. Each report showing data of a specific month (Date). What I am trying to do is to create measures to setup PLAN values based on the values from 1st month. 1) Reduction target per month based on 1st report values (values will be equaly divided per month, so the reduction target per month is equal each month) 2) commulated reduction 3) cummulated target backlog in stock In my example I have created a short table showing "Items in stock" values per country, per month. Target is to bring the "Items in stock" to zero by the end of the year. So the Plan should use the inital values from 1st month and divide it by 12 to be able to compare the plan per month by actuals per month. In my Dashboard I want to show current values per month as well as PLAN redurction target in each month. So the Visual shows the report data in the ROW for each month... Do you have an idea how to solve my litte problem? I really should appreciate your tips. Example Table
