Forum Discussion
Tableau to PowerBI conversion
SUM(max([Inclass],[Graduated])) / LOOKUP(SUM(max([Inclass],[Graduated])), -1)
Below is the sample output from the formula ( LOOKUP(SUM(max([Inclass],[Graduated])), -1).
| A | Year | Group level | Number | Size | Rquired Result | Graduated | Inclass |
| 2015-1- Spring | 2015 | F | 1 | 3 | 1 | 0 | 5,306 |
| 2015-1- Spring | 2015 | F | 2 | 3 | 5,306 | 5 | 3,962 |
| 2015-1- Spring | 2015 | F | 3 | 3 | 3,962 | 77 | 3,296 |
| 2015-1- Spring | 2015 | F | 4 | 3 | 3,301 | 185 | 2,763 |
| 2015-1- Spring | 2015 | F | 5 | 3 | 2,840 | 417 | 2,406 |
| 2015-1- Spring | 2015 | F | 6 | 3 | 2,591 | 769 | 1,970 |
| 2015-1- Spring | 2015 | F | 7 | 3 | 2,386 | 998 | 1,598 |
| 2015-1- Spring | 2015 | F | 8 | 3 | 2,366 | 1,211 | 1,300 |
| 2015-1- Spring | 2015 | F | 9 | 3 | 2,298 | 1,355 | 1,052 |
- DataVitalizer
Super User
Hi rintu
If you want to write that formula in DAX, try this code
MeasureName =
VAR CurrentSum = SUMX(SUMMARIZE('Table', 'Table'[Item], "MaxValue", MAX('Table'[Inclass], 'Table'[Graduated])), [MaxValue])
VAR PreviousSum = CALCULATE([CurrentSum], FILTER(ALL('Table'), 'Table'[Item] = EARLIER('Table'[Item])) - 1)
RETURN
DIVIDE([CurrentSum], PreviousSum)
Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated
