Forum Discussion

365Sdx's avatar
365Sdx
Frequent Visitor
6 years ago

VAR with multiple values

Hi, I'm trying to get values for the same week last year. I can't seem to use the SAMEPERIODLASTYEAR function as it takes it too literally & pulls in values for the same date last year instead of th...
365Sdx's avatar
365Sdx
Frequent Visitor
6 years ago

Hi Martyn, thanks for looking at this.

 

I tried it but it's not quite working as the table will be rolled up most of the time (i.e. not showing the time data) & each row will almost always be for multpled weeks.

 

Do you think there's something similar to SELECTEDVALUES that can deal with all selected values or a better way of trying to get values for the 'equivalent eek' last year?

 

Thanks

MartynRamsden's avatar
MartynRamsden
Solution Sage
6 years ago

Hi 365Sdx 

 

Sorry that didn't work out for you.

There are a few other ways to tackle this but it's hard to recommend anything without fully understanding your data model.


Are you able to share your pbix? Make sure you remove any sensitive data before you do.

 

Best regards,

Martyn