Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate difference between Min. & Max

Hi all,   I have a dataset that shows orderlines per row. Similar to this table: Item no. Revenue Quantity Sales Price Column Item1 10 1 10 Item1 24 3 8   I am trying to c...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    just figured out it was utterly simple. haha

     

    Min. SP = MIN(InitiativeMonitor_table[Sales Price DKK column])
    Max SP = MAX(InitiativeMonitor_table[Sales Price DKK column])
    Min. Max SP dif. = [Max SP]-[Min. SP]
Anonymous's avatar
Anonymous
Not applicable
5 years ago

just figured out it was utterly simple. haha

 

Min. SP = MIN(InitiativeMonitor_table[Sales Price DKK column])
Max SP = MAX(InitiativeMonitor_table[Sales Price DKK column])
Min. Max SP dif. = [Max SP]-[Min. SP]