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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Ashish_Mathur,

 

thanks for your response. Unfortunatly it didnt work.

 

Please see the image below. The MIN function only accepts a column reference as an argument.

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi Anonymous,

 

Your bracketing is wrong.  Close the MIN bracket before the *.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Ashish_Mathur,

     

    Thanks now its working on the right way. But i dont see the total sum on the column measure on the last row. It just give a €0.00 as total.

     

    Any suggestions?

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    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.