Regarding issue of getting month names of current year and prev year name in same column

[Hari_Gopal]

When I am selecting fiscal year in slicer, I am getting only month names of the current fiscal year. But I want to get Previous fiscal year along with the month names of current fiscal year. Can anyone help me to solve this in dynamic way? 

[Anonymous]

Hey @Hari_Gopal 

In your slicer of year you can choose the option of Before to get what you want.

[Anonymous]

Please accept it as a solution if it was helpful @Hari_Gopal 

[Hari_Gopal]

Hi @Anonymous 

Thank you but it isnt helpful for my requirement

[Anonymous]

@Hari_Gopal 

We don't know your data table so we cannot see where is that value field come from. Please show an original data table and an expect output table.

Here is a fantastic article for the best way to post data:

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best regards
Paul Zheng

[Hari_Gopal]

Hi @Anonymous 

You can get the pbix file having dataset here,

https://drive.google.com/file/d/1NM6OKH4Ks0V50kFwM3zK4pYM7pfqCMcB/view?usp=sharing

Expected Output:

[Hari_Gopal]

Please help me to solve the above issue in dynamic way

[VahidDM]

Hi @Hari_Gopal 

Your question is not straightforward. Can you please share the result table you are looking for?

Appreciate your Kudos!!

[Hari_Gopal]

Hi @VahidDM ,
I want to get like this