Forum Discussion
Count of Previous Case Values
Hi Anonymous ,
I have created a simple sample, please refer to it to see if it helps you.
Create a measure.
Measure = CALCULATE(COUNT('case log'[ID]),FILTER(ALL('case log'),'case log'[Case ID]=SELECTEDVALUE('case'[CASE NO])))Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
What is the lateset case? How to get it? By End time or start time? In your sample, the lateset case is ASGHVJ? If it is, does the measure result is 3? The below?
| asvdsahvhsg677 | ASGHVJ | ||||
| sahgxsakjaw223 | ASGHVJ | ||||
| sdcsavbhsa677 | ASGHVJ |
I would like you to give me a table that outputs what you want and explains the calculation method in words. Sorry to trouble you.
How to Get Your Question Answered Quickly
Please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ahh yes, sorry for the confusion.
The [Case TABLE] has a (CreatedDate) Col.
So i want to get the previous cases by an account i'll have to filter by date but will it give all the previous cases ?
Regards,
Shubham
Hi Anonymous ,
I have created a simple sample, please refer to it to see if it helps you.
Create a measure.
Measure = CALCULATE(COUNT('case log'[ID]),FILTER(ALL('case log'),'case log'[Case ID]=SELECTEDVALUE('case'[CASE NO])))Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.