Countrows that dont match a related table

[Anonymous]

Hi All,

I am busy with a measure that count rows of calls excecpt the days and calls of holidays.

Can anyone help?

kind regards,
Ezz

[Anonymous]

Hi @Anonymous ,

You can refer the solutions in the following threads to achieve it.

Calculating number of days between two dates

How exclude holidays from networking days

If the above ones are not applicable for your scenario, please provide some sample data of these three tables(Calls, Date and Holidays) and your expected result. It is better if you can explain more details with examples. Thank you.

Best Regards

Rena

[amitchandak]

@Anonymous , do you have a holiday . Assume you have date table with Holiday

measure

calls = calculate(count(Table[callid]),[WeekDay]=1)

A column in date table

WeekDay = if(weekday([Date],2) <6,1,0)