STD

I am not sure what Granularity is, but I will go read your link and maybe I will find out. ( I am fairly new to dax)

Allthough the result I posted is correct, it s not dynamic, I can make the average dynamic, but since the std did not work I opted to go for the average over the FY since that is the way it was done in excel. I achieved this through a measure

AVERAGE = CALCULATE(AVERAGE(Column), ALL(Dates), VALUES(Dates[FY])), I then wrote this measure to a column in my table, then another column which calculated the variance and so on and so forth. 

Here is the example of what I have and what I wanto achieve, but dynamically so that if I select month, or week, I will see my average, UL, LL for that particular month or week. Well, mine is dynamic in the sense that in changes form fy to fy, but stays static for smaller periods. First Column is my data values, others are all calculated columns