Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone
I have some issue about function sameperiodlastyear,
I want to compare data between present year and last year value by using sameperiodlastyear, for whole data is ok, but when i filter select some product, i found my date data is not continue because "The relationship between date table and data table is both relationship " then the function is not calculated, so i try to solve with crossfilter function to "active single relationship" but it won't work.
Could anyone can suggest solution for this issue?
@TK_TG , Hope you are using a date filter. And that is 1-M single direction join. Not bi-directional join
Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |