Forum Discussion
Solved
DAX for CALCULATE Using a Column with a Date as Filter
Hi I have a table that holds a identifier column and a max_eff date column. I'm trying to do a simple Calculate formula to obtain a count for all the assetnums that have a max_eff date of 1/1/20...
Hi,
One of these should work
2021 Starting Asset Count = CALCULATE(COUNTA('Program Status'[assetnum]), 'Program Status'[max_effdate] = DATE(2021,1,1))2021 Starting Asset Count = CALCULATE(COUNTA('Program Status'[assetnum]), FILTER('Program Status','Program Status'[max_effdate] = DATE(2021,1,1)))Hope this helps.
Ashish_Mathur Both work. Thank you!
You are welcome.