Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
27 | |
23 | |
22 | |
20 |
User | Count |
---|---|
57 | |
41 | |
24 | |
24 | |
21 |