Forum Discussion
DAX issue
Hi, Please help me to convert the following Tableau calculation in DAX.
{ FIXED [Student Id]:MAX(IF [Academic Period Id] = { FIXED [Student Id]:MAX([Academic Period Id])} THEN [Credits Earned] END)}
Thank you!
1 Reply
Anonymous
when all other are column , especially [Credits Earned]
a new column
=
if([Academic Period Id] = maxx(filter(Table, [Student Id] = earlier([Student Id])), [Academic Period Id] , [Credits Earned], blank())
when [Credits Earned] is a measure
a new measure
=
if(max([Academic Period Id]) = maxx(filter(allselected(Table), [Student Id] = max([Student Id])), [Academic Period Id] , [Credits Earned], blank())refer LOD- FIXED (Level of Details): https://youtu.be/hU-cVOwDCvY
Tableau Vs Power BI: https://www.youtube.com/watch?v=tAmg00Wf_cw&list=PLPaNVDMhUXGYzjFASXjdY7GNoFxvlkR54
