I just got stuck on an issue, that I guess should be easy, but I just cant seem to solve it. I have searched the forum and tried several of the threads out there, but…just no luck ☹
So, I have a mastertable with information, including volume per Month.
What I want to achieve:
I want to be able to compare Volumes compared to different months. For instance; Compare September volumes vs October volumes. Also, between years if possible. See picture below, I want to be able to see (A) compared to the specific months I choose.
Date – There is a datekey in each table with relationship to to a master datetable
Unique ID . There is a unique ID for a Service structure, called “SID”.
One more thing.... (feel like Steve Jobs here...) @v-shex-msft: It works perfect per SIN level (as the formula suggest) but if I drill down on "HostName" level, which can be found in table "DetailedVolumes" it breaks. Is there a way to modify it so it would work on both levels, both "Host Name" and "SIN" ?