IF FUNCTION IN POWER QUERY

[aam1932]

Hai all

Any possible that i want the result to determine D (debit) C (credit) not only based only amount column, but based on the total that particular account in the table as below:
As example, acc_code now currently showing debit amount of 19746434.24, how ever actually i have fews other BU and if i total up all the account code the amount negative, the result in the column D C, should be C and not D.

Thank you

 

[sandy666]

so post (again) REPRESENTATIVE example where I can sum Amount for the same criteria: BU, FY and ACC
and you didn't answer for my question post#8

anyway all your examples are NOT representative

maybe post a link to the shared excel file with your data via GoogleDrive, oneDrive or any similar
I don't see any confidential data in your examples

 

[GraH]

Might it be you are replying to the wrong Guy?

 

[sandy666]

try

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Type = Table.TransformColumnTypes(Source,{{"BU", type text}, {"FY", type text}, {"ACC_CODE", type text}, {"AMOUNT", type number}}),
    Group = Table.Group(Type, {"FY", "ACC_CODE"}, {{"Sum", each List.Sum([AMOUNT]), type number}}),
    IF = Table.AddColumn(Group, "DC", each if [Sum] > 0 then "C" else "D"),
    Merge = Table.NestedJoin(Type,{"FY", "ACC_CODE"},Table1,{"FY", "ACC_CODE"},"Table1",JoinKind.LeftOuter),
    Expand = Table.ExpandTableColumn(Merge, "Table1", {"DC"}, {"DC"})
in
    Expand

however it works with your examples but I am not sure it will work with your original data