How to create a custom column for comparing between of 2 numbers?

0 votes
Hi

How do I create a custom column which compares if a value existed between two other numbers rather than using the compare operators like >, =, <, <=, >=?

For example I have two tables like a DIM table and I need to create a custom column which shows a string instead of a number and my facct table existed in between of each range of these numbers

So,How to do this?
Jun 28 in Power BI by Phalguni
• 1,010 points
37 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Power BI

0 votes
0 answers

How to create measure out of column

Hi, Need help in the problem faced in ...READ MORE

Aug 14 in Power BI by anonymous
• 210 points
30 views
0 votes
0 answers

How to count of category values in a column?

How to count of category values in ...READ MORE

Oct 30 in Power BI by ch
• 3,290 points
7 views
0 votes
1 answer

How to create final table based on Joins of two tables in power BI?

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1 in Power BI by Cherukuri
• 31,840 points
256 views
0 votes
1 answer

Add Column Count_of_people across two tables to get the count of people from a city.

Hi Anitha, 1. Merge both tables, using City ...READ MORE

answered Mar 22 in Power BI by Cherukuri
• 31,840 points
35 views
0 votes
1 answer

How to add multiple reference lines on a bar/ column graph?

Hi, Follow below steps: 1. Add a bar/ column ...READ MORE

answered Mar 26 in Power BI by Cherukuri
• 31,840 points
184 views
0 votes
0 answers

How do you create a relationship between two queries with same database?

I have some database view with several ...READ MORE

May 28 in Power BI by Phalguni
• 1,010 points
41 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 41,990 points
48 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 41,990 points
82 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 41,990 points
61 views
+1 vote
1 answer