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
Hi
In my project I have three measures, the first one is a custom date, the second one is the same day but from the past month and the third one is the same day but from the past year. The first date measure is set to take the value of another table wich contains a traditional calendar, the selection is made by a data segmentation filter in the canvas.
Until this point everything works well but I have to use the values of the three dates explained before to filter the data of another table, to create a resume table that allow me to present the data at the choosed date and the other two periods for comparison, but I can't get the correct definition for the last resume table. I think it is a problem of the date selected through a data segmentation filter.
I show a basic diagram of what I need to do:
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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!