Forum Discussion
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...
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.
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.