Cumulative total LY to date

Nurry90 · November 16, 2021, 9:19pm

Hi All,

Quick question, I need to correct the total showing at the bottom of the table. I cannot use any in built date functions as I dont have a standard date table. Total showing is for the whole of last year.
Any suggestions?

SamePeriodLastYear =
CALCULATE([Total Sales],
SAMEPERIODLASTYEAR(‘Date Table’[Date]))

Cumulative Total LY =
IF(ISBLANK(‘Basic Calculations’[Total Sales]), BLANK(),
CALCULATE(‘PY Calculations’[SamePeriodLastYear],
FILTER(ALLSELECTED(‘Date Table’),
‘Date Table’[Date]<=MAX(‘Date Table’[Date]))))

Keith · November 16, 2021, 9:23pm

why can’t you put in the EDNA Extended date table into the Model.

thanks
Keith

Nurry90 · November 16, 2021, 9:28pm

Hi Keith,

I had to build my own date table based on my criteria.

Keith · November 16, 2021, 9:33pm

You know you don’t have to use all the columns with that date table.

Did you mark your table as a date Table? I believe if its not make date table than you can’t use the built in functions?
thanks
Keith

Nurry90 · November 18, 2021, 11:34pm

Hi Keith,

Yes I have my date table marked. I’ll see if I can build in the date table functions above to my dates, if this is the only way.

EnterpriseDNA · November 21, 2021, 10:36pm

Bumping this post for more visibility.

ankit · November 25, 2021, 6:11am

Hi @Nurry90 - I have tried at my end and doesn’t seems to be facing any issues. Please share the sample PBIX file for me to look further.

Thanks
Ankit Jain

EnterpriseDNA · November 26, 2021, 12:17am

Hello @Nurry90, just following up if you still need help with your inquiry?

If you do, kindly provide the information that @ankit is requesting above so they can help you further.

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.