Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |