Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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.
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.
I meant to say ... the Total Amounts for only those Total Amounts that also have Model ID = Rem.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |