Forum Discussion

Enan's avatar
Enan
Helper I
3 years ago
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...
Need Help
Show and Tell
Enan's avatar
Enan
Helper I
3 years ago

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?

  • Enan's avatar
    Enan
    Helper I
    3 years ago

    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) ))