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 have two columns:
Actual Planned CountTheRow
P1 10 2 1
P2 6 10 1
P3 5 1
P4 12 1
I would normally use something like this:
if(isnum(Actual),1,if(isnum(Planned),1))
So if P1 has either a Planned or an Actual amount - the row is counted,
Also: wh is it so hard to type into this section? Tab and returns are odd???
Jo
Hi @Anonymous
You could do
IF( NOT( ISBLANK( [Actual] ) ) || NOT( ISBLANK( [Planned] ) ) ,1 ,0)
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 |
Thank you - this is very strange - I am translated into Spanish? And I cannot press tab or enter ... I think it is because I am the opposite part of the globe?
Already
@Anonymous , you will get both the English and Spanish messages. just check the correct ticket in your profile.
I think I need lessons on how to use this interface ... let alone power BI!
-
Hi , @Anonymous
Could you please tell me whether your problem has been solved?
If it is, please mark the helpful replies or add your reply as Answered to close this thread.
It will help other community members easily find the solution when they get the similar issue.
Best Regards,
Community Support Team _ Eason
Hi @Anonymous ,
Every post here is translated from english to spanish and vis-a-varsa.
Your post is also in english. Click the icon
on top right of this window you will see both posts. Right now there is no way to switch of spanish.
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 , Create a new column like
if(not(isblank([Actual])) || not(isblank([Planned])),1,0)
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |