Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I have a period table that has a bi-directional relationship on my date table.
When selecting one of the periods the date table filters accordingly, but my measure using SAMEPERIODLASTYEAR does not change. As if it's ignoring the filter on the date table.
My measure is this
test = CALCULATE([Sum Gross Sales], SAMEPERIODLASTYEAR('Calendar'[Date]))
Thanks
I have a period table that has a bi-directional relationship on my date table.
please explain your reasoning for that.
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
177 | |
85 | |
70 | |
63 | |
55 |