cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Phil_P Frequent Visitor
Frequent Visitor

Generating A New Table

Hi,

 

I am very new to Power BI and need some assistance. I have two tables (with no related columns) and want to generate a third from the two. The idea is to generate a weekly statistics table (each Sunday) for my key transactions.

 

So my input tables are:

 

Table 1

Date Table 
DateDOW
01/01/2018 00:002
02/01/2018 00:003
03/01/2018 00:004
04/01/2018 00:005
05/01/2018 00:006
06/01/2018 00:007
07/01/2018 00:001
08/01/2018 00:002
09/01/2018 00:003
10/01/2018 00:004
11/01/2018 00:005
12/01/2018 00:006
13/01/2018 00:007
14/01/2018 00:001
15/01/2018 00:002

 

Table 2

Key Transaction   
ApplicationKey TransactionTimeLink
App1Trans 13ABC
App1Trans 23BCD
App1Trans 32CDE
App2Trans 41DEF

 

And what I am trying to create is:

Result    
DateApplicationKey TransactionTimeLink
07/01/2018 00:00App1Trans 13ABC
07/01/2018 00:00App1Trans 23BCD
07/01/2018 00:00App1Trans 32CDE
07/01/2018 00:00App2Trans 41DEF
14/01/2018 00:00App1Trans 13ABC
14/01/2018 00:00App1Trans 23BCD
14/01/2018 00:00App1Trans 32CDE
14/01/2018 00:00App2Trans 41DEF

 

Can anyone assist?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Generating A New Table

@Phil_P,

 

You may use DAX below to add a calculated table.

Table =
CROSSJOIN (
    Table2,
    SELECTCOLUMNS ( FILTER ( Table1, Table1[DOW] = 1 ), "Date", Table1[Date] )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Generating A New Table

@Phil_P,

 

You may use DAX below to add a calculated table.

Table =
CROSSJOIN (
    Table2,
    SELECTCOLUMNS ( FILTER ( Table1, Table1[DOW] = 1 ), "Date", Table1[Date] )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Phil_P Frequent Visitor
Frequent Visitor

Re: Generating A New Table

That works brilliantly - Thanks

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 47 members 1,206 guests
Please welcome our newest community members: