Need Urgent help in calculating with slicer selection

[Srinivas3350]

I am having requirement that i need to show resepective of my selection in the slicer it needs to show previous FC 
 example lets say we have  Forecast 11 which is FC11 so when ever i select FC11 in the slicer the top table should show same values for FC11 but in the bottem table It needs to show FC10. can anyone help how to acheive this with a measure or however you suggest. 

Thanks

srinivas

[Anonymous · Accepted solution]

HI @Srinivas3350,

I think you may need to use if statement to check the current hierarchy level and write Dax expression to calculate the corresponding result.

Clever Hierarchy Handling in DAX - SQLBI

BTW, it seems like you are work with text value instead of numeric or date type values, I'd like to suggest you use the current text value to find out correspond date ranges. Then you can use these date range to find out previous fiscal date and use in Dax expression as filter condition to calculate.

Regards,

Xiaoxin Sheng