Export and Import

Question

Hey Guys,&nbsp;i have below data and trying to achieve Export (based on load date) and Import (based on discharge date)If i select one country, i need to show the Net exports as below.&nbsp;Please HELP!!!Truck&nbsp;KT&nbsp;ProductLoad_PortLoadCountryLoadSubregionLoadRegionLoadDateDischarge_PortDischargeCountryDischargeSubregionDischargeRegionDischargeDateTruck1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8WaterVasilikoCyprusMedMed26-Jul-24BurgasBulgariaMedMed09-Aug-24Truck2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8PetrolEleusisGreeceMedMed30-Jul-24Exxon AntwerpBelgiumNW EuropeNW Europe13-Aug-24Truck3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8DieselAugustaItalyMedMed08-Aug-24Santa PanagiaItalyMedMed22-Aug-24Truck4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10WaterUst LugaRussian FederationBalticsFSU+Russia10-Aug-24MarsaxlokkMaltaMedMed24-Aug-24Truck5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5PetrolUst LugaRussian FederationBalticsFSU+Russia17-Aug-24Ust LugaRussian FederationBalticsFSU+Russia31-Aug-24Truck6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6DieselArkhangelskRussian FederationOther FSU+RussiaFSU+Russia26-Aug-24Unknown-MedUnknownMedMed09-Sep-24Truck7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17WaterDortyolRepublic of TurkiyeMedMed03-Sep-24RotterdamNetherlandsNW EuropeNW Europe17-Sep-24Truck8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8PetrolUnknown-SpainSpainMedMed09-Sep-24Unknown-US PADD 1United States of AmericaUS PADD 1United States Region23-Sep-24Truck9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10DieselExxon AntwerpBelgiumNW EuropeNW Europe10-Sep-24New YorkUnited States of AmericaUS PADD 1United States Region24-Sep-24Truck10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8WaterBurgasBulgariaMedMed12-Sep-24VasilikoCyprusMedMed26-Sep-24Truck11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10PetrolExxon AntwerpBelgiumNW EuropeNW Europe14-Sep-24EleusisGreeceMedMed28-Sep-24Truck12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7DieselSanta PanagiaItalyMedMed15-Sep-24AugustaItalyMedMed29-Sep-24

joe_barry · Accepted Answer

Hi Kannan4444&nbsp;
&nbsp;
Create a date/calendar table, link in my bio.
&nbsp;
Create an Active One to Many Relationship from the Date Table date column with the Load Date and do the same for the Discharge Date, but this will be an in-active relationship
&nbsp;
Create a measure for LoadDate
KT Load Date = SUM('Table'[KT])
Then another for Discharge Date
KT Discharge Date = CALCULATE(SUM('Table'[KT]), USERELATIONSHIP('Date'[Date], 'Table'[Discharge Date])
&nbsp;
When creating any visuals with date inforation, use the columns from the Date table and add the measures to the visuals to be able to compare.
&nbsp;
Hope this helps
Joe

Forum Discussion

Export and Import

1 Reply

Related content

EXPORTING

export from visual table

Report Builder - Export failed

Can't Export to PBIX

PDF Export not Exporting Full Pages