Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team
i want to calculate my data , except SUNDAY .
Possible ??
this is my table
Thanks before any response
Syaiful Efendi
Solved! Go to Solution.
@Anonymous
Please try like
calculate(sum(Table[Count]), Table[Day]<>"Sunday")
calculate(sum(Table[Count]), weekday(Table[Date])<>1)
@Anonymous
Please try like
calculate(sum(Table[Count]), Table[Day]<>"Sunday")
calculate(sum(Table[Count]), weekday(Table[Date])<>1)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |