1 2 Previous Next 20 Replies Latest reply on Sep 4, 2018 1:11 PM by Deepak Rai

    LOD Expression not working correctly.

    Stephen Crocker

      I have a Power BI Calculated field

      Most Recent Rate = CALCULATE( MAX(LoadRelationship[RatePerTon]), FILTER(LoadRelationship, LoadRelationship[SalesDeliveryDate]=MAX(LoadRelationship[SalesDeliveryDate]))) that I want to convert to a tableau LOD Expression.

      Here is what I have for a LOD expression in Tableau

      {FIXED [Origin City State]: SUM(IF {FIXED [Origin City State]:MAX([SalesDeliveryDate])}=[SalesDeliveryDate] THEN [RatePerTon] END)}

       

      I need to get the Most Recient Rate Per Ton based on the Origin City State

      What am I doing wrong?

        1 2 Previous Next