Forum Discussion
Replace exact one null in column.
- 4 years ago
Anonymous you can't replace it but you can add a new column in PQ or DAX with a logic that will create the column you need. The logic will require that the row will have something that will distinguish it from the other rows in your table
- 4 years ago
Are the values in the other columns unique? Meaning could you create a conditional column (either in Power Query or data view) to add in your value? Something like this: = IF( [unique column] = ABC), 25000$, [Price]
Just as I thought. Great! Thanks for help!
Anonymous my pleasure 🙂
Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas.
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂