Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello all,
I started using Power BI a week ago so I am the newest of the noobs. Sorry about that! Thank you in advance for any help. Anwyay, I have imported a table of data into PBI and I need to pull the following information from it using a measure. I am very familiar with Excel and and I am familiar with Visual Basic and UI Path so I have somewhat of a leg up. Here is what I need to create, for starters:
For the table, when area (area is a column in the table) = 1, show all customers with revenue >1 and <20k for each month in the last four months – show customer and their revenue for each month
For the table, when area (area is a column in the table) = 1, show all customers with revenue 20k to <40k for each month in the last four months – show customer and their revenue for each month
Same for area 2-5 but you can skip doing the areas 2-5 as I can replicate area 1 to areas 2-5
Any ideas? Thanks again for any help
Solved! Go to Solution.
Expand the filter pane and filter the measure with the criteria of <=20000.
Hope this helps.
Hello and thank you.
The first table shows the sample data.
Customer Name | Jun-23 Revenue | ||||||||
1ST DIBS | $291,223.99 | ||||||||
250W Fashion Group LLC | $100,826.37 | ||||||||
A.M.D | $88,791.06 | ||||||||
A.W. CHESTERTON CO. | $79,877.04 | ||||||||
ABB | $705,957.93 | ||||||||
Abbott Laboratories | $92,846.90 | ||||||||
Accelleron | $1,933.40 | ||||||||
ACCESS USA | $694,992.79 | ||||||||
Accuray | $195,585.62 |
The second table shows what I am seeking - I know the data doesn't correlate - that's because the tabel is very large but you should get the idea I'm after - Thanks!
Revenue < $20,000 USD | |
Account Name | Jun-23 Revenue |
Accelleron | 1933.4 |
Airbus Group | 1210.28 |
Alaris | 3037.22 |
AMERLUX | 0 |
ATEC SPINE INC | 6324.69 |
Automated Pet Care Products, LLC | 17339.88 |
AVANOS MEDICAL INC | 5567.25 |
AVANOS MEDICAL INC LAS VEGAS | 53.72 |
| |
I just do not understand anything. I see no relation between the question in your original post and your latest one.
That is because I have tried to simplify this as much as possible in the hope that someone will show me how to write a measure. Ignore the first post. I've got customer names and their revenues. I need a measure to show the customer names and revenues if below 20000
Expand the filter pane and filter the measure with the criteria of <=20000.
Hope this helps.
Hi,
Share data in a format that can be pasted in an MS Excel file and show the expected result.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
82 | |
63 | |
62 | |
58 |
User | Count |
---|---|
159 | |
115 | |
103 | |
75 | |
66 |