14 Day Average Fixed in DAX

[Anonymous]

Hi,

i have created a Measure called percentage i.e.

Percentage. = DIVIDE(DISTINCTCOUNT('appointment_service_detail'[appointment_id]),CALCULATE(DISTINCTCOUNT('appointment_service_detail'[appointment_id]),ALLSELECTED()))

Result:

Now ,

i need to create Dax for 14 days Error Average ---please help

[Anonymous]

what about average?

[Anonymous]

Hi , 

How can i calculate the average measure i.e Called Percentage above?

[Anonymous]

how can i calculate Dax not filter for  14 days Average of 

Percentage. = DIVIDE(DISTINCTCOUNT('appointment_service_detail'[appointment_id]),CALCULATE(DISTINCTCOUNT('appointment_service_detail'[appointment_id]),ALLSELECTED()))

[vicky_]

You can use DATESBETWEEN(DateColumn, TODAY(), DATEDIFF(TODAY(), -14, DAYS)) as part of your calculate filter to get the last 14 days.
Or if you have a date column, just add in a relative time filter for the last 14 days (but this will affect the rest of your tables).