Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dears,
Here, I face a quesion that has been borthering me for several days.
First, below figure is my modeling relationship(1 is Fact Table, 2~4 are dimension Table), I would like to do a dynamic dimension form about Current Year VS Prebious Year,
But, the PY result aloways on the PY year Not on Current Year(By week & By Month), By day is correct, like below figure
Dex:
I guess mybe this mapping relationship affect my Dex, but I DON'T have any better choice,hope someone could help me to identify this problem, thanks!
Time Intelligence functions like SAMEPERIODLASTYEAR expect a calendar table that is contiguous and covering (including the result of the computation)
User | Count |
---|---|
91 | |
77 | |
71 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |