Forum Discussion
New Measure - Calculating Numbers Between a Date Range
Hi,
I am currently having the issue that my Earned % Complete and Planned % Complete is not being filtered by the Reporting Period slicer. It is showing an overall percentage instead of the fortnight percentage.
Is there a measure that allows me to just filter the earned/planned data between the fortnight date period? Or a special way of doing it haha.
Thank you
2 Replies
Dylo_Bloomfield , there are a few ways, You can use an independent date table
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzMHello amitchandak
Thank you for the help!
I am still a bit stuck on the measure... I currently have made the below but have come to an error.
I have linked the PS 3 and Calendar (Milestone Source) tables, but I am just trying to show the earned % complete for the fortnight between 01/07/2023 and 14/07/2023. I tried applying filters but they do not work on the visual (I don't know why). Hope this makes sense and Thank you friend.
