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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

Top Solution Authors
Top Kudoed Authors