Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
105 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
107 | |
90 | |
64 |