I am new to power BI.
I have two columns for water quantity and concentration of pollutants, so i want to calcualte daily pollutant loading.
How should I create a measure to calculate = daily(water-quantity)*dailyaverage(pollutant)
Go to Solution.
Put your Date in a visual and then use this measure:
Measure = SUM([Water-quantity]) * AVERAGE([Pollutant])
Proud to be a Datanaut!
View solution in original post
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!