Hi all,
I'm new to Power BI so was after some help with targets. Any help would be greatly appreciated.
I currently have a graph showing totals per group over the last 4 years + current year to date. I would like to add a target line in the table which would start at 2013, this target would be calculated by taking the average of this group over a 4 year period (2012/13/14/15), every year after this would be 6% year on year.
I have already worked out the targets for each groups and created the separate table. I have a column in the graph data table and target table to link together but can't see how I would link the target data in to the graph on specific group and year.
Is there a way I can calculate Targets on the fly?
Can I add targets to a table from a different data set?
Thanks in advance.
