Forum Discussion
Calculation in DAX
{ FIXED [Student Id]:MAX(IF [Academic Period Id] = { FIXED [Student Id]:MAX([Academic Period Id])}
THEN [Gender Code] END)}
Please help me convert above Tableau calculated field in DAX.
Thanks!
1 Reply
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
