Thanks Ashish for your response,
by any chance do we have the possibility to solve this without using Filters for Financial Year?
I mean, possible to find the total of SamePeriod previous Year sales at row level for each Month. Like Sum of all April related sales, May Sales etc...
I do not understand your question but for computing same period last year, you will have to select a specific year.
Just change the table visual to matrix visual and drag Financial Year field into Columns value.
See this pbix file as below.
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!