Hi,
I am fairly new to Power BI, I want to recreate the scenaro below on power bi. the below is an excel sample table chosen from Sample sites.
| Volume | New Frequency |
| - | 0 |
| 106,910.00 | 1 |
| 173,218,900.18 | 14 |
| 346,330,890.37 | 6 |
| 519,442,880.55 | 1 |
| 692,554,870.74 | 1 |
| 865,666,860.92 | 0 |
| 1,038,778,851.10 | 0 |
| 1,211,890,841.29 | 0 |
| 1,385,002,831.47 | 0 |
| 1,558,114,821.65 | 1 |
| 1,731,226,811.84 | 0 |
| Volume | New Frequency |
| 0 | =FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15) |
| =E20 | =FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15) |
| =$D$5+E17 | =FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15) |
| =D6+$E$17 | =FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15) |
| =D7+$E$17 | =FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15) |
| =D8+$E$17 | =FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15) |
| =D9+$E$17 | =FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15) |
| =D10+$E$17 | =FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15) |
| =D11+$E$17 | =FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15) |
| =D12+$E$17 | =FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15) |
| =D13+$E$17 | =FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15) |
| =D14+$E$17 | =FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15) |
Thank you
