Forum Discussion
Comparison to minimum
Hello Everyone, I have a data table that I use that has the revenue dollars per mile by hour in the day. What I have done so far is calculated the revenue per mile in each hour of the day and I want...
Anonymous ,
As new columns
Overall Min = min(Table[Dollars per mile])
diff = [Dollars per] -[Overall Min]
As new measures
Overall Min = CALCULATE ( min(Table[Dollars per mile]), ALLSELECTED (Table) )
Dollars per Sum = sum[Dollars per]
diff = [Dollars per Sum] -[Overall Min]
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.