How to shift dates (years) based on a filter

Hello , 

is it possible to share some data sample ? , 

to create a dynamic measure you should do the following for the fiscal year : 

1 : create a column in the table you have with this measure : 

if(month(table[date])<[star month],year(table1[date])-1,year(table1[date])) +
if(moht(table1[date])>=[start month],1,0)

////// 

then to have this work make a parameters in the modeling tab : 

new parameter  :  as per the image attached : 

Nem : Start Month , Type whole Number , Min 1 , MAX 12 , leave it as default ( 1 ) as for January . 


Then , when bar chart is created you can youse fiscal year calculated column as the x axis and the count column as the y axis , the user can adjust the start month and the chart will be updated dynamiclly bas on the selection . 

Kindly accept as a solution if it works with you and a kudo would be appreciated . 

Regards ,