Processing Count or distinctcount except SUNDAY

[Anonymous]

Hi Team

i want to calculate my data , except SUNDAY .

Possible ??

this is my table

Thanks before any response

Syaiful Efendi

[amitchandak · Accepted solution]

@Anonymous 

Please try like

calculate(sum(Table[Count]), Table[Day]<>"Sunday")
calculate(sum(Table[Count]), weekday(Table[Date])<>1)