Forum Discussion

IAmCare's avatar
IAmCare
Frequent Visitor
8 years ago

SamePeriodLastYear

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('...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

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's avatar
IAmCare
Frequent Visitor
8 years ago

I am getting this error mesage

when i do this