Forum Discussion
Solved
Count for current month
Hi, i want to make a measure to count below dates from dim table: 1. Today's date count 2. Current month date count basically counting dates from my fact table gives me number of my staff not ava...
Enan , for current month use
Current Month Count = Calculate(Count(Fact_NOAV_data[Date])filter( Fact_NOAV_data ,eomonth(Fact_NOAV_data[Date],0)=eoMonth(Today(),0) ))
refer
hi Enan
try like:
Today_Count= Calculate(COUNTROWS(Fact_NOAV_data), Fact_NOAV_data[Date]=Today())
Current Month Count = Calculate(COUNTROWS(Fact_NOAV_data),Month(Fact_NOAV_data[Date]=Month(Today()))
Thanks bro for helping.
todays_count is working fine with countrows.
but current month count with countrows is not working its gives total number of records in the table. I tried with calendar table as well but same answer. How to resolve this plz?