Forum Discussion
Calculate first value for months
Hi guys, I would like to create a measure that calculates first value for each month based on filter. This is an example: Date System Value 09.07.2020 1st 266471,4 ...
I did not understand the logic of 350k? How did you arrive at this value?
Cheers!
Vivek
Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter
Hi vivran22
I explained this in my first post 🙂
Expected result without filters:
| 1st | 350000 |
| 2nd | 350000 |
That means that for each system with have 2 months 7 and 8 and for each month we get first value. E.g.
1st system - july 266471,4286 and august 83528,57143
2nd system - july 86292,85714 and august 263707,1429