Calculated tables

Question

Hi Guys,&nbsp;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 · Answer

Hi&nbsp;Mike5049&nbsp;
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

Forum Discussion

Calculated tables

1 Reply

Related content

Direct Lake Model - Calculated Column/Tables

How to search specific word in table filter Calculations

Table Visual not Matching Calculated Visual

Directlake semantic model, calculated table

PowerBI - Matrix table, hide values used only for a visual calculation