Forum Discussion

JackReagan's avatar
JackReagan
Frequent Visitor
8 years ago
Solved

Custom Column Power BI

I am hoping the collective minds can help me with a simple example using the custom columns in Power BI.    I have a rather simple data set which has three columns; ProjectID, ModelID and TotalAmou...
  • RolandsP's avatar
    RolandsP
    8 years ago

    You should write following DAX formula:

     

    Custom column = IF (TableName[ModelID] = "Rem", TableName[Total Amount], Blank() )

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Why do you wan to use a Custom Column.  Use a measure instead.  Drag Project ID to the row labels and ModelID to the filter section.  Select the criteria as Rem.  Write the following measure

     

    =SUM(Data[Total Amount])

     

    Hope this helps.

RolandsP's avatar
RolandsP
Resolver IV
8 years ago

You should write following DAX formula:

 

Custom column = IF (TableName[ModelID] = "Rem", TableName[Total Amount], Blank() )

JackReagan's avatar
JackReagan
Frequent Visitor
8 years ago

Thanks Roland.  Your DAX formula helped me create my measure.  I appreciate your help.