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
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
Dear Amit,
Thank you for your guidance.
Measure worked successfully.
Current Month Count = Calculate(Count(Fact_NOAV_data[Date]),filter( Fact_NOAV_data ,eomonth(Fact_NOAV_data[Date],0)=eoMonth(Today(),0) ))