Forum Discussion
Solved
Merge measures into column for filtering data
Hi guys! Can anyone answer a question about power bi? I have a table with a date column. I need to solve a problem as follows: 1- A filter must be created to select the date. 2- The dashboard shou...
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!
Hey gpuc09_
To achieve this in Power BI, you can create a measure that dynamically selects both the chosen date and the previous day. See the example below. The approach uses the var selecteddate and pday (previous day's date) to adjust the data context accordingly