Forum Discussion
Count values at a specific date
I would like to create a measure that counts the number of account numbers at the earliest date in the table.
The earliest date would be 31/01/2019 and I would like to distinctly count the number of account numbers at that time. I cannot hard code the date as it updates every month.
I have this so far:
Count of Accounts at MIN Date =
Prefer creating a date dimension and join with your fact and try like
CALCULATE(DISTINCTCOUNT(Clients[AccountNumber]), FILTER(Date, Date[Date]=minx(Clients,Clients[HoldingDate])))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
1 Reply
Prefer creating a date dimension and join with your fact and try like
CALCULATE(DISTINCTCOUNT(Clients[AccountNumber]), FILTER(Date, Date[Date]=minx(Clients,Clients[HoldingDate])))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin