Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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!
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
13 | |
11 | |
7 |