Forum Discussion

Kannan4444's avatar
Kannan4444
Helper I
1 year ago
Solved

Export and Import

Hey Guys,  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.   Please ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Joe_Barry's avatar
    Joe_Barry
    1 year ago

    Hi Kannan4444 

     

    Create a date/calendar table, link in my bio.

     

    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

     

    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])

     

    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.

     

    Hope this helps

    Joe

Joe_Barry's avatar
Joe_Barry
Solution Sage
1 year ago

Hi Kannan4444 

 

Create a date/calendar table, link in my bio.

 

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

 

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])

 

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.

 

Hope this helps

Joe