Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to Create Aggregated table from fact table

hi all, i am new to Power BI. learned few tips and tricks and trying myself. can you help to support on how to create aggregate table for using in the report. below screen is sample. i have more dim...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , a new table in DAX like


    summarize(Table, Table[company], Table[LOB] , Table[Lcurr] , "Deduction",calculate(sum(Table[Deduction]), Table[Type] = "YU")
    , "value",calculate(sum(Table[value]), Table[Type] = "YU")
    , "Gcurr", calculate(max(Table[Gcurr]), not(isblank(Table[Gcurr] )))
    "Deduction1" ,calculate(sum(Table[Deduction]), isblank(Table[Type] ))
    , "value1",calculate(sum(Table[value]), isblank(Table[Type] )))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , a new table in DAX like


summarize(Table, Table[company], Table[LOB] , Table[Lcurr] , "Deduction",calculate(sum(Table[Deduction]), Table[Type] = "YU")
, "value",calculate(sum(Table[value]), Table[Type] = "YU")
, "Gcurr", calculate(max(Table[Gcurr]), not(isblank(Table[Gcurr] )))
"Deduction1" ,calculate(sum(Table[Deduction]), isblank(Table[Type] ))
, "value1",calculate(sum(Table[value]), isblank(Table[Type] )))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Amit,

Really appreciate your support on this. it's working for SGD.

but, my numbers not correct for EUR. in my earlier screen I entered the type in the wrong cell.