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.
Need help with simple DAX formula. DAX will go in Column B. If The adjacent cell in Column A is not blank, then place a 1 in the adjacent cell in Column B. Thanks for any help!
Solved! Go to Solution.
HI @Anonymous
Column_B=
IF(Table[COLUMN_A] = BLANK(), BLANK(), 1)
OR
Column_B=
IF(LEN(Table[COLUMN_A])=0, BLANK(), 1)
OR
Column_B=
IF(ISBLANK(Table[COLUMN_A]), BLANK(), 1)
Did I resolve your issue? Mark my post as a solution!
Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@Anonymous
assuming you are creating a new column and the name of the column you are pointing is "SourceColumn"
=If(ISBLANK([SourceColumn]), 0,1)
Hope this Helps
Vijay Perepa
If you find this as solution please share kudos and mention this as solution.
Thanks
Proud to be a Super User!
HI @Anonymous
Column_B=
IF(Table[COLUMN_A] = BLANK(), BLANK(), 1)
OR
Column_B=
IF(LEN(Table[COLUMN_A])=0, BLANK(), 1)
OR
Column_B=
IF(ISBLANK(Table[COLUMN_A]), BLANK(), 1)
Did I resolve your issue? Mark my post as a solution!
Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Thanks this worked perfect!
That doesn't sound like DAX at all. Do you maybe mean Power Query? What have you tried so far?
Unfortunately I don't have permissions to do the edit in Power Query. Just trying to find a way to make the change in the data table. I just need to have a column populate 1 for every adjacent cell that is not blank. I need the "1's" to use as a count field since my table visual is not populating/counting all the data as it should.
is that computation something you only need to do once (calculated column) or can the result be impacted by filter choices (measure) ? I guess the former?
Yeah it's just needed once.
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 |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |