Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

How to calculate two columns based on Excel formula?

Hi guys,   I am a PowerBI noob and i would like to have your help. I  have a table that with different price group called Group A Each row on Group A has a different price which are inserted in co...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi Anonymous,

     

    Try this calculated field formula

     

    =if(HASONEVALUE(DFMORDERTEMPLATES[AMOUNT]),min(DFMORDERTEMPLATES[AMOUNT])*[TOTAALBETALENDLEDEN],SUMX(SUMMARIZE(DFMORDERTEMPLATES,DFMORDERTEMPLATES[AMOUNT],"ABCD",min(DFMORDERTEMPLATES[AMOUNT])*[TOTAALBETALENDLEDEN]),[ABCD]))

    Hope this helps.

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

If [price group A] is a column, and [C] is a measure, you only need to create a measure like below to calculate the multiply value.

Total = SUM(Table1[Price Group A])*[C]

 

To help us better understand your scenario, please provide detailed data in source table and show us all necessary formulas you have used in this report.

 

Regards,
Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi v-yulgu-msft,

     

    Thanks for your reaction. how can i share my pbix files to you?