Calculated tables

[Mike5049]

Hi Guys,

Below is a calculated table based off an SQL data base. I am trying to find a way to add the values for 'Total RC Metre Rate Calculation' per each 'drilling date' and use this combined total to compate to the 'RC Total Pen Cost.' I then want to create an IF statement so the largest out of the two values gets selected.
As you can see below my current IF statement isn't working correctly because the value for 'RC Total Pen Cost.' is only present for one row per 'drilling date' despite being the cummulative value for all the entries for the same date. Can I please get some assistance.

[Ritaf1983]

Hi @Mike5049 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523