Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

Create a table with diference values for rows

Hello guys! I have two tables related by a date column (Data -> DataAjust).

A table receives monthly data per row (Table 1).

 

The other table is a calendar that runs until 2030 (Table 2).

I would like to create a new table with the view of these two.

 

FelipeEng_0-1614695044186.png

 

I tried to create a dax with this, but it returns an error in Union due to the number of different columns.

Table 1 and Table 2 have different row values.

 

FelipeEng_1-1614634649544.png

 

Any ideia? 

 

Thanks!

 

1 REPLY 1
Anonymous
Not applicable

I tried something for Power Query, but I have no knowledge of M for that.

But it can be a step to be taken.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.