Forum Discussion
Really Dumb ALL question
I have a page with a filter on it where Datetable[Actual]="Yes". this limits the data to todays date However I want ot count how many days are in the month chosen in totla so I wrote this expecti...
PC2790
Community Champion
Community ChampionI have tried to replicate your issue and it works fine for me.
See below:
[Actual] is a calculated column similar to what you described:
Actual =
if('DateTable'[Date] <= TODAY(),"Yes","No")
Let me know if I am missing from this sample.
Yup I have no idea why it doenst work as seems obvious? i've moved the page filter otthe visuals as only solution. Bit wierd, but thnaks for looking at this