Forum Discussion
Last Period (snapshot data)
Hi Anonymous ,
I see, the point is the relationship.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Parry - Yes, I am familiar with that link. I am not able to share a sample of the data model as it is huge and contains confidential data. I thought the information I provided already would be sufficient, and I explained the expected result - which is to shift the values back by one month (the value showing in April should instead show in March, etc...).
I also provided the dax formula, explained that I do have a date table, explained the connection between the date table, and provided a picture of the visuals. Short of uploading my actual file, which I cannot do, I am not sure what else is needed, but happy to try to add more information if I can.
Hi Anonymous ,
Which table is the Month column in your visual from?
Measure = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[date]=EDATE(SELECTEDVALUE('Table (2)'[date]),-1)))
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jay,
Unfortunately your formula just returned blank values.
The month on the visual is coming from the dates table (month). Here is my original formula. The "as of date" is connected to the dates in date table.
Measure 5 = CALCULATE(SUM(Flu_Snapshots[Actual Value]),ENDOFMONTH(Flu_Snapshots[As Of Date]))Hi Anonymous ,
I see, the point is the relationship.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.