SamePeriodLastYear

[IAmCare]

Maybe I am missing something but shouldnt the current for 2017 be the Last for 2018?  Here is my code

Current = CALCULATE(COUNTROWS('FactWholesale'))

Last = CALCULATE([Current],SAMEPERIODLASTYEAR('DimDate'[Date]))

578 for 2018 and 594 for 2017 is correct for the current but shouldnt  last for 2018 be the current for 2017 which is 594

mething but shouldnt the cu

[Ashish_Mathur]

Hi,

You should not have a year in the Fiscal month column.  In the DimDate Table, extract the Month using the =FORMAT([Date],"mmmm").  Drag this Month column in the visual.

[IAmCare]

I am getting this error mesage

when i do this

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[IAmCare]

I think I know what is going on.  Our fiscal month

September 2017 ran from

8/28/2016 -  10/01/2016

 fiscal month

September 2018 ran from

8/27/2017 -  9/30/2017. 

Our fiscal calendar  ends on the last Saturday of the month.  Is there a way to get the sameperiodlastyear to work with this type of monthly set up?

[v-chuncz-msft]

@IAmCare,

For any time intelligence function, you could implement a custom DAX formula.

https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/

[IAmCare]

I do not know how to share the link to my PBIX without sharing all of my work, which I do not want to do.