Forum Discussion

alevandenes's avatar
alevandenes
Icon for Helper IV rankHelper IV
5 years ago

add columns from different tables into one table

Hi all,   i have created a visualization in PBI Desktop that looks like this table below The Number of occurences is coming from one table The number of units shipped is coming from another...
Need Help
alevandenes's avatar
alevandenes
Icon for Helper IV rankHelper IV
5 years ago

Hi Amit,

Thank you for your reply.

Number of occurences: DISTINCTCOUNT(issue number) from Issues table

Number of Units shipped: SUM(units shipped) from Sales date

 

i have a dimensional Date table that links Creation Date of Issue to Shipment Date

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    alevandenes , then you can create a measures from both tables and analyze it with common dimensions like date?

    • alevandenes's avatar
      alevandenes
      Icon for Helper IV rankHelper IV
      5 years ago

      yes, i am doing that but i need to use output of these measures as input for another measure. so i thought of creating a stating table in the background. but i dont know which formulas to use to do that