Forum Discussion

MTracy's avatar
MTracy
Icon for Advocate I rankAdvocate I
8 years ago

Rebuilding report - different results with SAMEPERIODLASTYEAR measure... why?

  I've had a report based on Support Ticket data that used multiple tables due to different categories of tickets we have.  Recently, I learned how to merge them into one "master" table using SQL an...
Need Help
MTracy's avatar
MTracy
Icon for Advocate I rankAdvocate I
8 years ago

Hi v-jiascu-msft, thanks for keeping up on this!

I have had something unusual happen.  When I loaded the rebuild pbix file (the new one that didn't work like the old one), I suddenly noticed the calculations were working!  I didn't touch the DAX formulas, the relationships, or anything.   There was a refresh of the underlying SQL Server data, and some other DAX calculated columns added for unrelated reporting... that's it.   No relationship changes, it simply started to work.

 

 

I'm not entirely sure I can still call this "broken".   I do have to say that the sudden change is quite a mystery.   I can't think of what would have changed this.   I did install the November update in the middle of all this, so maybe that had something to do with it?   Thoughts anyone?

 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi MTracy,

 

I tried to find out the mode of this issue. But it is intermittent. So I asked you about this. I'm glad you can go on now. I will appreciate it if you can close this thread. You can post a new one anytime you encounter an issue.

 

Best Regards,

Dale