Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.