Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyCount Blank and Zero in New Column
Hi good day,
Can anyone pls need help on new calculated column, from table below how to have an output if bank or Zero will be equal to 1 in new calculated column and blank if not started column is greaterthan 0.
Thank you
Hi AllanBerces
You can use Dax :New column = if([Not Started]=0,1,BLANK())pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
3 Replies
- Ritaf1983
Super User
Hi AllanBerces
You can use Dax :New column = if([Not Started]=0,1,BLANK())pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
AllanBercesHi Ritaf1983 thank you very much working perfectly
- Ritaf1983
Happy to help 🙂