LY calculation, Date hierarchy - potentiel bug?

[davidell]

Hi guys,

I've come across a problem, which I'm not able to understand and don't know, if its a bug or not?

I'm working with the adventureworks dataset. Here I've created three calculated measures:

Total Sales =SUM('Sales Data'[Total Revenue])

Total Sales = SUM(FactInternetSales[SalesAmount]) 

Total Sales LY = CALCULATE([Total Sales];SAMEPERIODLASTYEAR(DimDate[FullDateAlternateKey]))

When I change the date dimension (FullDateAlternateKey) into showing full dates (dd-mm-yy). Everything works fine (see the attached pictures). However when I change the FullDateAlternateKey into showing DateHierarchy, the values are missing in Total Sales LY but the grand total i shown.

Is this a bug?

Thank you very much

Regards,
David

[v-yulgu-msft]

Hi @davidell,

Based on my test, no matter whether I set full dates (dd-mm-yy) or DateHierarchy, the LY calculation can return correct results. Please see below image.

I used the same DAX formulas as yours. In your scenario, please re-create the measures and visuals to see whether issue persists. If possible, you can share your .pbix file for more analysis if your data source was connected with import mode.

Best regards,
Yuliana Gu

[davidell]

Hey Yuliana,

Sorry for the late response and thank you for your reply.

I tried what you said, but it still produces the same result

I simply dont get it.

Best regards,

David

[v-yulgu-msft]

Hi @davidell,

Please share your pbix file so that I can check for you.

Regards,
Yuliana Gu

[davidell]

Silly question..

How do I upload .pbix files to the community? ;/

Is there a button somewhere?

[v-yulgu-msft]

Hi @davidell,

You can also upload your .pbix file to OneDrive and share the link with me.

Regards,
Yuliana Gu