Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 available for work.
i have seperate table for calandar as well which is linked to fact table.
i have tried to create below measure but it does not give correct value.
Today_Count= Calculate(Distinctcount(Fact_NOAV_data[Date]), Fact_NOAV_data=Today())
Current Month Count = Calculate(Count(Fact_NOAV_data[Date]),Month(Fact_NOAV_data[Date]=Month(Today()))
thank your help.
Solved! Go to Solution.
hi @Enan
try like:
@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
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 , 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) ))
hi @Enan
try like:
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?
or
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
104 | |
100 | |
99 | |
38 | |
37 |
User | Count |
---|---|
158 | |
124 | |
76 | |
74 | |
63 |