How to declare a variable?

Hi All,

I am facing some challenges in making dynamic filters in Power BI. I am making YOY% , QOQ% , YTD , QTD for our analytics.

For Example, we are using (Current Year(FY16-17)-Last Year(FY15-16))/Last Year(FY15-16) for calculating YOY. I have to a financial year column and using it as slicer.

Now, the concern is, if I select FY15-16, I want that YOY to get updated accordingly i.e.,  FY15-16 should be current year now and FY14-15 should be last year. So YOY should show corresponding growth (Growth of FY15-16 over FY14-15).Similarly growth should be updated for other selections as well.

Similarly for QOQ, YTD & QTD, we have the same requirement. So kindly guide me as to what steps should I follow to achieve it.

Regards,

Satish Kumar