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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors