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.
I have the following formulas to calculate the variation in the number of customers from one year to another:
@MrAndrewth85 , Make sure dim_date is used in slicer and visual as per need. Join with Dim_date should be single directional and it should have all dates and marked as date table
Try LY like
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
Thanks for your answer, amitchandak!
At the moment, the solution you have given me has not worked. In the model, DIM_Date and FACT_Customers tables are linked by Date Key, so I think it should be enough for the slicer to affect the measurements, but it is not doing it, and neither did it with the calculation that you suggested me to do for customers LY. Let me understand a little more about being sure dim_date is used in slicer and visual as per need. Do you mean that I use it in the filter of each visualization?
Thanks again for your answer!
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 |
---|---|
48 | |
26 | |
20 | |
14 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |