Power BI Numeric Data Match Report

• Tila: Closed
• Palkinto: $75
• Vastaanotetut työt: 7
• Voittaja: rahmatginanjar

Winner

Kilpailun tehtävänanto

I require a Power BI expert to work on numeric data within two columns in my dataset.

Tasks:
- The task requires comparing both columns to find numeric matches.
- Upon finding a match, a report needs to be generated.

The ideal candidate should:
- Have experience working with Power BI and numeric data.
- Understand complex data comparison.
- Have expertise in report generation based on data matches.

This project requires accuracy and strong analytical skills in data interpretation and manipulation.

I have 5 columns, vendor name, product, from qty, To Qty, unit price. The vendor is giving a price for quantities between the from and To Qty.

Example of data table:
acme vendor, widget, 1, 25, $10.00
So the price for any quantity between 1 and 25 will cost $10.00

Ace vendor, widget 4,6,$11.00
Big corp, widget, 7,25,$15.00
Dog Inc, part-A ,2,10,$25.00
Cat Corp Part-123, 2-5

I need to be able to search the data let’s say for any pricing that is for a qty 6.

So in the table it should result in Acme, Ace, and Dog pricing.

I assume there needs to be. Table of sequential
Numbers from 1 through 3000. So there can be a filter for the user to enter there quantity that they want to use for the search. That’s a guess.

This needs to work on older version of Power BI.

Suositellut taidot

• Analytiikka
• Power BI
• Tilastoanalyysi