Filtering by date if it occurs during WEEKNUM

[android1]

Hi,

How do you filter if a date is during a WEENUM ie  Week 33 is between dates August 13, 2018 August 19, 2018

In the below measure the ClientsList[EndDate] is a date column. I'm trying to filter the below measure if ClientsList[EndDate]

occurs in vw_PivotChargesFrontPage[Visits_Week]

Invoiced Potential = CALCULATE(DISTINCTCOUNT(ClientsList[ClientRef]),vw_PivotChargesFrontPage[FinalisedCharges] <> 0.00,ClientsList[EndDate] <= MAX(vw_PivotChargesFrontPage[Visits_Week])

[v-frfei-msft · Accepted solution]

Hi @android1,

I made a sample as you descripted and create relationship between ClientsList and vw_PivotChargesFrontPage. By the measure, we can get the reslut as we excepted.

Invoiced Potential = CALCULATE(DISTINCTCOUNT(ClientsList[ClientRef]),FILTER(RELATEDTABLE(vw_PivotChargesFrontPage),vw_PivotChargesFrontPage[FinalisedCharges]<>0))

For more details, please check the pbix as attached. If it doesn't meet your requirement, kindly share your pbix to me.

https://www.dropbox.com/s/e02dgi5fuipsx86/WEEKNUM.pbix?dl=0

Regards,

Frank