Forum Discussion
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 TotalAmount. Project ID is a unique ID, ModelID has two values Rem and Orig and Total Amount has various amount values. I want to create a custom column that will display the Total Amounts for only those Total Amounts that also have Model ID = Orig.
Data set example:
Project ID ModelID Total Amount
123 Rem $400.00
123 Orig $780.00
234 Rem $559.00
234 Orig $700.00
Custom column should display values for only those records that have ModelID = "Rem"
Report Example with Custom column
Project ID Custom column
123 $400.00
234 $559.00
You should write following DAX formula:
Custom column = IF (TableName[ModelID] = "Rem", TableName[Total Amount], Blank() )
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.
6 Replies
You should write following DAX formula:
Custom column = IF (TableName[ModelID] = "Rem", TableName[Total Amount], Blank() )
Thanks Roland. Your DAX formula helped me create my measure. I appreciate your help.
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.
Ashish
You were right. Once I figured out the measure functionality it seemed to be the right path. Whats great about DAX is that you can do one thing many ways. I appreciate your help.
Tom
You are welcome.
I meant to say ... the Total Amounts for only those Total Amounts that also have Model ID = Rem.
