New Measure - Calculating Numbers Between a Date Range

[Dylo_Bloomfield]

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

[amitchandak]

@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/O653vwLTUzM

[Dylo_Bloomfield]

Hello @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.