Forum Discussion
Helper ISAMEPERIODLASTYEAR is blank
Hello,
I am new to power BI
I am trying to get LY YTD for my sales $. I am not getting any error, but just blank data.
I did add below but again it just returns blank with no error. Please help!
ALL(Dates)
Hi nhaghani ,
According to your description, I create a sample.
I think you should put a date column in the visual, the SAMEPERIODLASTYEAR function should be based on an exact date.
LY-YTD Dotcom = CALCULATE(SUM('Ulta Dotcom'[Sales]),SAMEPERIODLASTYEAR('Ulta Dotcom'[Ending-Date]))I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi nhaghani ,
I'm clear, you can modify the formula like this:
LY-YTD Dotcom = IF ( MAX ( 'Ulta Dotcom'[Ending-Date] ) > DATE ( YEAR ( TODAY () ) - 1, MONTH ( TODAY () ), DAY ( TODAY () ) ), BLANK (), CALCULATE ( SUM ( 'Ulta Dotcom'[Sales] ), SAMEPERIODLASTYEAR ( 'Ulta Dotcom'[Ending-Date] ) ) )Best Regards,
Community Support Team _ kalyj
23 Replies
- VahidDM
Super User
Hi nhaghani
Check this link: https://www.vahiddm.com/post/weekly-time-intelligence-dax
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/ 
v-yanjiang-msftCommunity Support
Hi nhaghani ,
According to your description, I create a sample.
I think you should put a date column in the visual, the SAMEPERIODLASTYEAR function should be based on an exact date.
LY-YTD Dotcom = CALCULATE(SUM('Ulta Dotcom'[Sales]),SAMEPERIODLASTYEAR('Ulta Dotcom'[Ending-Date]))I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
nhaghaniHello,
Please see this with date below. If this column is YTD, I shouldn’t see 1/23/2021, 1/30/2021, etc…
I would just want it to show 1/2/2021 at this point
- v-yanjiang-msft
Hi nhaghani ,
I'm sorry I'm not clear the logic of just show 1/2/2021 at this point.
The function SAMEPERIODLASTYEAR will return a value as long as the same date of last year has a value.
Could you please show more of your sample and expected outcome? This will help resolve your problem faster.
Best Regards,
Community Support Team _ kalyj
- nhaghani
Hello,
I loaded a calendar for all dates in 2021 and 2022 but I still see full 2021 instead of just up to week 6.
how do i share my .pbix file here?
please see my sample.. my data should not go past week 6... and it is still doing the same
LY YTD = IF ( MAX ('2022'[ENDING DATE].[Date]) > DATE ( YEAR ( TODAY () ) - 1, MONTH ( TODAY () ), DAY ( TODAY () ) ),CALCULATE(SUM(Sheet1[SALES $]), SAMEPERIODLASTYEAR('2022'[ENDING DATE].[Date])))- v-yanjiang-msft
- nhaghani
What is your calculation?
you should use sameperiodaslastyear function
