Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have two tables showing sales with dynamic date filters;
I want to create measure to compare the % difference between the values on the left vs right, however I can't get the date range filters to apply correctly. The measure I'm trying to use is the below;
I've attached some sample data and how I would like it to work using excel and pivot tables.
Hi, @Nafeesa Do you have 2 fact tables please? what does your table relationship model look like?
Can you provide dummy data for testing?
HI Dima,
There is just the one fact table with the data, presented in two different tables with date slicers.
I've attached some sample data.
@Nafeesa Please provide the pbix file.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 58 | |
| 45 | |
| 42 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 172 | |
| 107 | |
| 92 | |
| 54 | |
| 46 |