Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
munna825
New Member

SamePeriodLastYear broken out by Market

I am using sameperiodlastyear to calculate the total volume produced last year for the associated market. however in the matrix screenshot below i am getting the correcr grand total but the breakout for the market is missing. Am I using the wrong formula?

 

CM PY =
CALCULATE([MTD Service Volume],SAMEPERIODLASTYEAR('Date'[Date]))

munna825_1-1624045601430.png

 

4 REPLIES 4
munna825
New Member

I have a slicer with date filter between 5/1/2021 to 5/31/2021. I am using the matrix visualization and in columns i am splitting based on Markets from a dim table.

Hi,

If my suggestion did not help, then share the link from where i can download your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-janeyg-msft
Community Support
Community Support

Hi, @munna825 

 

Is your problem solved? Since there is no error in the code, we need more information to judge.

Can you share some sample fake data and your desired result? So we can help you soon.

 

Best Regards

Janey Guo

 

Ashish_Mathur
Super User
Super User

Hi,

In the slicer, ensure that you have selected a Year and Month from the Date Table.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.