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.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.