Please issue sample of my data set, My data is large data below i am showing sample
I want to calcualte distinct count of client code based on cases id we received last 90 days by running total. (last three months if we received cases from the client which means client is alive)
I want to represents the data like below to create visual
Go to Solution.
Hi @VeluRavi ,
Please try to use following measure formula if it suitable for your requirement:
VAR curr =
MAX ( 'Table'[Case created date] )
COUNTA ( 'Table'[case no] ),
ALLSELECTED ( 'Table' ),
[Case created date]
>= DATE ( YEAR ( curr ), MONTH ( curr ) - 3, 1 )
&& [Case created date] <= curr
VALUES ( 'Table'[Client Name] )
Have you tried using the built-in Running Total Quick Measure? Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Proud to be a Datanaut!
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.