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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
bipowerbix
Helper I
Helper I

Help with replicating existing Calendar or Duplicating Measure

I am working on a report, I want to recreate the Elements in the FIRST date, in the newly created Second Date table.

There is no way to copy or duplicate the already created FIRST Date table, Also I cannot go into the Query builder to see what's happening here because it's done on the report view or Model view. Is there a youtube link to create such Calendar Tables?

bipowerbix_0-1678484886865.png

The formulas are straightforward using the existing functions such as DAY(), MONTH(), YEAR(), etc, 

 

I wanted to know what the below icon before Date 

bipowerbix_1-1678485010268.png 

stands for,

 

and how is it different from the below icon before Date, looks like a Calendar

bipowerbix_2-1678485077846.png

because both have the same format in column tools, not sure why there is a different icon assigned to them.

bipowerbix_3-1678485187550.png

 

Could someone explain this power bi feature?

 

The formula used to create SECOND DATE 2 = 

 

 

CALENDAR(DATE(2023,1,1),TODAY())

 

 

 

I am trying to replicate the FIRST DATE table, 

THE FIRST DATE table looks like this:

bipowerbix_4-1678485647774.png

 

 

1 REPLY 1
Ashish_Mathur
Super User
Super User

Hi,

I don't think there is a way to just duplicate a table created in DAX.  In the new Table, you will have to copy/write the column formulas individually.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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.

Top Solution Authors
Top Kudoed Authors