Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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
User | Count |
---|---|
36 | |
30 | |
28 | |
25 | |
24 |
User | Count |
---|---|
51 | |
50 | |
35 | |
34 | |
29 |