User Profile
jmuniz
Frequent Visitor
Joined 6 years ago
User Widgets
Contributions
- 1.5KViews0likes0Comments
Re: IF Statement Help
These are different formulas that I have been try to use but always get the "Token Eof expected". IF [Result] =null then null else if [Result]>=3 then 1 else 0 if ([Result] =null, "",if([Result]>=3,1,0)) if [Result] = "" then "" else [Result]>=3 then 1 else 0 Any tips?1.5KViews0likes2CommentsRe: IF Statement Help
Hi PradipMCT After your recommendation I fixed the first part. To give you a background of my purpose of the new column is the following: If the numbers on the "Result" column is 3 or more, give me 1, if not, give me 0. However, since some of the numbers on the "Result" column are in blank, I want power bi to return those as blank also. :smileyhappy: The final purpose is that I will count how many employees have 3 or more.1.5KViews0likes0CommentsRe: Way to display a "word" instead of a "number".
Hi jdbuchanan71: So, this can be used for the final aggregation? The final aggregation probably will be on decimals and can look like this: 1 to 1.99 is Novice 2 to 2.99 is Emerging 3 to 3.99 is Effective 4 to 4.99 is Advance 5 and up is Expert2.5KViews0likes2CommentsRe: Way to display a "word" instead of a "number".
Hi Anonymous : I have done it before, however (correct if I'm wrong since I'm a new user using power bi), the system will not calculate the last column showing here since is a text and I want it does the average to display my original table showed at the beginning of the thread.2.5KViews0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.