Forum Discussion
Merge measures into column for filtering data
Hey gpuc09_ ,
No worries! I’ve put together a DAX measure that calculates and displays the values for both the selected date and the previous date. Take a look at the attached image and file to see how it works. Hope it helps!
Hello @marcelsmaglhaes!
Thanks for your help, but it's not exactly what I wanted... Let me see if I can be more specific and send you a draft of the dashboard!
Suppose I have this data (Image 01), where I have several values for the dates from October 1st to October 10th. When I create a filter, with a single selection, of the dates present in my column (Image 02), I need the table to show the values of that selected date and the previous day, in separate rows (Image 03).
I think it's clearer this way! If you can edit the draft to get the result, that would be great!
Thank you very much!
Dataset values:
Hey gpuc09_ ,
No worries! I’ve put together a DAX measure that calculates and displays the values for both the selected date and the previous date. Take a look at the attached image and file to see how it works. Hope it helps!