Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculated Column

Hi Guys,   Please refer the below  table where I have the first 2 columns in my report and the 3rd is the desired column when the Annual Usage is divided by 1000 where ever type name is Electric.  ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a measure like

    Annual Usage (MWh) = round(CALCULATE(SUM(Deals[AnnualUsage]),FILTER(Deals,Deals[typename]="Electric"))/1000.0,0)

     

     

    Or new column like

    new column = if([typename]="Electric", round([AnnualUsage]/1000.0,0), 0) +0 

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

Anonymous , Try a measure like

Annual Usage (MWh) = round(CALCULATE(SUM(Deals[AnnualUsage]),FILTER(Deals,Deals[typename]="Electric"))/1000.0,0)

 

 

Or new column like

new column = if([typename]="Electric", round([AnnualUsage]/1000.0,0), 0) +0 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for your help !!!

     

    The below solved my issue

     

    new column = if([typename]="Electric", round([AnnualUsage]/1000.0,0), 0) +0 

     

    Regards,

    Himanshu