topic Re: sameperiodlastyear result in blank page when de-selecting year inbetween in DAX Commands and Tips

sameperiodlastyear result in blank page when de-selecting year inbetween

Invisibleman — Sun, 14 May 2023 20:26:46 GMT

Dear all,

I have in my power bi, 4 years. Where I am getting the previous year's value also. However, if I de-select a middle year, then I am getting the white field, so there's an error.

As you can see below on the picture. As you can see I can select sequencel years, but I can't de-select a middle year.

I have tried with sameperiodlastyear and also with dateadd minus 1 year, the problem remains.

Ithe formula I have is;

Revenue All Years 1 year earlier =

calculate(

'Calculations Sales Report Related'[Revenue All Years],

(SAMEPERIODLASTYEAR(mapCalendar[Date])))

I can do with the (SAMEPERIODLASTYEAR(ALL(mapCalendar[Date]))) but then it shows me the total value of it all in each year. But I want to keep that only the values of that year is shown.

If anybody could help with this?

Thanks,

Hans

Re: sameperiodlastyear result in blank page when de-selecting year inbetween

Wilson_ — Sun, 14 May 2023 22:52:05 GMT

Hello Invisibleman,

The issue is SAMEPERIODLASTYEAR (and most/all date functions only work with an unbroken, continuous date range. Check out this previous post and see if it helps.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

Re: sameperiodlastyear result in blank page when de-selecting year inbetween

Invisibleman — Sat, 20 May 2023 07:08:53 GMT

Hello Wilson,

Sorry for the late reply. But I have checked and tried the solution. But that is not something that will work for my needs. As it seems that it will copy the needed data to a temp table. But this is not something I wish to do, as there are too many fields that I will need to copy.

But if there's a way to skip the error, then I am also okay. Even that if that wil mean, that it will not show the value.

Regards,

Hans