Reply
Sibrulotte
Helper IV
Helper IV
Partially syndicated - Outbound

Sameperiodlastyear shows empty when calender slicers use other fields than date

Hi,

I'm going crazy. I have a simple sameperiodlastyear function that reads as such:

 

NB_blitz_comp = Calculate([NB_blitz], SAMEPERIODLASTYEAR('Calendrier Maitre'[Date]))

 

Calendrier maitre is linked by date fields on the table where Blitz is calculated.

Whenever I use slicers that have that master calendar date field, wonderful results, I see my last years numbers. 

When I use any other fields of the master calender as a slicer (fiscal year for exemple),  NB_blitz_comp comes out empty.

 

 

I've done this in other documents and choosing the fiscal year works to perfection, and this isn't a really more complicated model. I really don't know what I should be looking for.

1 ACCEPTED SOLUTION

Syndicated - Outbound

Thank you for trying to help. 

I'm afraid I won't be able to get any data out of my company's secured area, even if I dropped all fields that contain descriptive data. Sorry.

 

 

But the good news is that I solved my problem on my own. I changed the relationship between the master calendar and the table to an actual date field. I was using a date ID field that was not formatted as a date.

 

View solution in original post

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Syndicated - Outbound

Hi,

Share the download link of the PBI file and show the problem clearly.


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

Syndicated - Outbound

https://fondsftq.sharefile.com/d-s35998c2d01934b2bbd9cf84b39b68ba9

 

Try selecting the year (année comptable) or the "Année à date" slicers that are part of the master calender.

Normaly this works impeccably with other documents where I have the same master calendar and the same "sameperiodlastyear" function. 

 

Année à date for exmeple chooses the dates that are included from the begining of the fiscal year to today. 

I could also add a Quarter slicer, and it's still not working as it does in other documents.

 

Syndicated - Outbound

That takes me to a sign-in page.


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

Syndicated - Outbound

Thank you for trying to help. 

I'm afraid I won't be able to get any data out of my company's secured area, even if I dropped all fields that contain descriptive data. Sorry.

 

 

But the good news is that I solved my problem on my own. I changed the relationship between the master calendar and the table to an actual date field. I was using a date ID field that was not formatted as a date.

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)