Forum Discussion

Gugge's avatar
Gugge
Icon for Helper I rankHelper I
6 years ago

IFERROR and SSAMEPERIODLASTYEAR gives error

Hi, I seem to hit an error I cant solve. I have two visuals in my PowerBI that is supposed to show sales in the same period as last year (and other info). If I filter on 2020 and July it shows sale...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Gugge ,

 

The IFERROR() function can‘t detect this error. Would you mind sharing your .pbix file? We may need to modify the formula of the measure.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Gugge's avatar
Gugge
Icon for Helper I rankHelper I
6 years ago

Hi v-lionel-msft ,

I cant share the pbix as it contains to much sensitive information.

I might have been unclear on my issue, the filters I'm using is the Chiclet slicers as below to help the users to easy do the filtering.

 

It's not a big issue in it self, more of an annoyance that an error is showing when only a month is selected. I've instructed the users to always choose a year also, but I like to have reports as user friendly as possible.

 

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Gugge ,

     

    When your slicer filters the data, the SAMEPERIODLASTYEAR function will be passed the wrong parameter, so the software reports an error.

    Maybe you can consider using other functions or adding conditional judgment statements to this measure.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.