Sum & Count on new table

[Jakelmy]

Hi i need help on shaping my data but i couldnt find a proper subject to visualize it. Hopefully i can explain here better.

I have 1 table contain inventory number & 3 different table indicate type of transaction.

This 3 table have transaction number with inventory number & quantity, this table have repeating inventory number with same transaction number indicate more detail in the product but its in another table.

And i have another 3 table contain unique transaction number & multiple time record.

What i want to do is first to have a new table having the master inventory code as column1 & 3 different type of transaction as column2 column3 column4 showing the count of how many time the inventory number have been use similar to countif in excel. And column5 column6 column7 to show the cumulative quantity of the inventory number similar to sumif in excel.

Really appreciate your help,

Thanks

[V-lianl-msft]

Hi @Jakelmy ,

Please provide more detail information to help us clarify this scenario.

See if you can paste the image of the sample data and the result you expected.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

General replacement for COUNTIF in Excel is something like:

COUNTROWS(FILTER('Table',[Column]="Something"))