sumifs using edit queries

[Anonymous]

I have replicated two sheets from excel as tables in power BI

Sheet 1:- 

table_name, rec_eff_dt,rec_create_dt, row_count, Valid_date

Sheet 2:-

This is a pivot table for finding the max rec_eff_dt for each table_name, create_dt and valid key record

table_name,rec_create_dt_Valid_date --> max(rec_eff_dt)

Next to this is another sumifs to dispay the row counts

The folrmula is as follows:-

sumifs(row_count,pivot.table_name,table_name,pivot.max(rec_eff_dt)=rec_eff_dt)

The results of this formula are bringing the row_count values for a table_name and if the table_name is duplicated then the row_count i summed.

How can I accomplish this in powerBI?

[v-yuezhe-msft]

@Anonymous,

You can use  the CALCULATE(SUM([YourColumn]),FILTER(<filter clause>)) DAX to reproduce sumifs result in Power BI Desktop, for more details about CALCULATE function, please review this article.

If you have questions about DAX, please share sample data of your tables and post expected result following the guide in this blog.

Regards,
Lydia