Forum Discussion
NewbieJono
Post Partisan
Post PartisanAdding more to a Total
The table below adds up volumes each day. However I need to add an additional 10,000 to day 1 which needs to appear in the total. whats the best method to do this
is this what you want?
Measure = if(max('Table'[date])=CALCULATE(min('Table'[date]),ALL('Table'))&¬(HASONEFILTER('Table'[range])),sum('Table'[value])+10000,sum('Table'[value]))pls see the attachment below
1 Reply
ryan_mayuSuper User
is this what you want?
Measure = if(max('Table'[date])=CALCULATE(min('Table'[date]),ALL('Table'))&¬(HASONEFILTER('Table'[range])),sum('Table'[value])+10000,sum('Table'[value]))pls see the attachment below