Target for different years

[bobbydave]

I have 3 files

• Metric (dimension)
• Budget (dimension)
• Metric Values (expression)

The common key across all is Metric. I have a calendar that sorts each file out by year and month YYYYMM (filename is YYYYMM_Metric.xlsx and YYYYMM_Metric_Values.xlsx

Howevver, Budget is a yearly file so it is named YYYY_Budget.xlsx

I've attached an output I am getting. When I load the files, everything appears fine if for one year but when my Target changes each year, it is going to show all target years in my output. This is showing 2015 and 2016 Budget data

This should look like below for 2016 data

and 2015 Budget data is

I know its got to do with my YYYY grouping.

Anyone any idea how to get the Year so that it matches my Calendar

Output of what I currently have attached.

Thanks

[pho3nix90 · Accepted solution]

Try again with this one.