Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 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
9 years ago

Hi v-yulgu-msft,

 

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

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

Hi Anonymous,

 

You can upload your pbix file on onedrive and attach the shared link here.

 

Regards,
Yuliana Gu

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

      Hi Anonymous,

       

      Try this

       

      =min(DFMORDERTEMPLATES[AMOUNT])*[TOTAALBETALENDLEDEN]

      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.