topic Re: Regarding issue of getting month names of current year and prev year name in same column in DAX Commands and Tips

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

Hari_Gopal — Mon, 01 Nov 2021 10:22:31 GMT

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?

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

Hari_Gopal — Mon, 01 Nov 2021 09:51:08 GMT

Please help me to solve the above issue in dynamic way

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

VahidDM — Mon, 01 Nov 2021 10:16:00 GMT

Hi Hari_Gopal

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

Appreciate your Kudos!!

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

Hari_Gopal — Mon, 01 Nov 2021 10:19:34 GMT

Hi VahidDM ,
I want to get like this

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

Anonymous — Tue, 02 Nov 2021 06:55:43 GMT

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

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

Anonymous — Tue, 02 Nov 2021 06:59:41 GMT

Hey Hari_Gopal

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

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

Hari_Gopal — Tue, 02 Nov 2021 07:27:54 GMT

Hi Anonymous

You can get the pbix file having dataset here,

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

Expected Output:

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

Anonymous — Tue, 02 Nov 2021 07:31:57 GMT

Please accept it as a solution if it was helpful Hari_Gopal

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

Hari_Gopal — Tue, 02 Nov 2021 08:56:08 GMT

Hi Anonymous

Thank you but it isnt helpful for my requirement