Forum Discussion
rpiboy_1
Helper V
2 years agoPrevious Period Pattern, inconsistent results
I have two fact tables joined to the same (well formed) date Table, both on 'Date'[Date]. In fact table 1 I'm using the following measure to calculate previous period for a sumed value: Prev...
- 2 years ago
rpiboy_1 Variables (VAR) despite their name are constants and once calculated remain the same value regardless of anything you might try to do. So, that's the reason for the results you are getting.
Greg_Deckler
Community Champion
2 years agorpiboy_1 Variables (VAR) despite their name are constants and once calculated remain the same value regardless of anything you might try to do. So, that's the reason for the results you are getting.
rpiboy_1
Helper V
2 years agoUgh... yeah, I've read that before, but I don't do this work day in and day out, so hard to remember all of the 'details'. Thanks!