cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Surafel
Helper I
Helper I

How to duplicate tables for another tables values

I have a table that does not contain a date column. The value in that column is consisitent for the entire year, but the report is filtered by month. As a result, I cannot visualze values from this table in a monthly report. Therefore, what I am trying to do is the following.

 

I have two tables Saving Target and Dates as follows:

 

 

Suppliers	Target in $	
Heck		255.00
Yummy		650.00
Dual		587.35	


Date
1/4/2021
2/4/2021
3/4/2021
4/4/2021
.
.
.

 

The desired output is as follows:

 

 

Suppliers	Target in $		 Date
Heck		255.00			1/4/2021
Yummy		650.00			1/4/2021
Dual		587.35			1/4/2021
Heck		255.00			2/4/2021
Yummy		560.00			2/4/2021
Dual		587.35			2/4/2021
Heck		255.00			3/4/2021
Yummy		650.00			3/4/2021
Dual		587.35			3/4/2021
.				.				.
.				.				.
.				.				.

 

 

Can anyone help me with this please?

1 ACCEPTED SOLUTION
Jihwan_Kim
Community Champion
Community Champion

Hi, @Surafel 

Please try the below for creating a new table.

 

New Table = CROSSJOIN('Saving Target', Dates)
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

View solution in original post

1 REPLY 1
Jihwan_Kim
Community Champion
Community Champion

Hi, @Surafel 

Please try the below for creating a new table.

 

New Table = CROSSJOIN('Saving Target', Dates)
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors