Forum Discussion
Data in different rows
Hi IF ,
I think the easiest fix is to also check the "#" in the slicer as shown in the image below:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for the reply. I tried and noticed that I have some cases with more than 2 types. I added 3 more rows to the sample. For example, Name=B, date=8.2022 has initial (4), second (2) and last (3). In this case the score should be 4/50 for initial type, 2/50 for the second type and 3/50 for the last type. Most of the data has only one type, but some of them having 2 or 3 types. Thanks again.
| Name | Month | Type | Score1 | Score2 | Score3 |
| A | 7.2022 | initial | 1 | Score1/Score2 | |
| A | 7.2022 | # | 24 | Score1/Score2 | |
| A | 7.2022 | initial | 2 | Score1/Score2 | |
| A | 8.2022 | second | 2 | Score1/Score2 | |
| A | 8.2022 | # | 34 | Score1/Score2 | |
| B | 7.2022 | initial | 1 | Score1/Score2 | |
| B | 7.2022 | # | 43 | Score1/Score2 | |
| B | 8.2022 | initial | 4 | Score1/Score2 | |
| B | 8.2022 | second | 2 | Score1/Score2 | |
| B | 8.2022 | last | 3 | Score1/Score2 | |
| B | 8.2022 | # | 50 | Score1/Score2 |
Hi IF ,
Please try following DAX:
score3 =
var cur_score1 = CALCULATE(MAX('Table'[Score1]),FILTER('Table','Table'[Type] = "#" && 'Table'[Month] = EARLIER('Table'[Month]) && 'Table'[Name] = EARLIER('Table'[Name])))
VAR newscore1 = IF('Table'[Score1] = BLANK(),cur_score1)
RETURN IF(newscore1 <> BLANK(),'Table'[Score2] &"/" & newscore1)
I think this is the result you want:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much, it is very closed. I provided two screenshots. If i don't select the month and type the result should be 10/93 (1+4+3+2)/43+50. Similarly if I select the month it should be 9 / 50. Regards.