cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kolumam Member
Member

Calculated table with calculated column

Hi All,

 

I need to create a calculate table which can compute the below calculated column.

Table name : Refresh

Column name: Last Refresh 

Forumla: Last Refresh = UTCNOW()

How do I acheive this using DAX?

3 REPLIES 3
rocky09 Senior Member
Senior Member

Re: Calculated table with calculated column

are you trying to get last refresh date/time or you are trying to create a table based on last refresh date.?

avdutta Frequent Visitor
Frequent Visitor

Re: Calculated table with calculated column

In edit query you at your existing data source, you can add a column like

= Table.AddColumn(#"Renamed Columns1", "Last Refresh Date", each DateTimeZone.FixedUtcNow() )

This will give you last refresh date.

Super User
Super User

Re: Calculated table with calculated column

@Kolumam Please try this as a "New Table" 

 

Refresh = ROW("Last Refresh",UTCNOW()) 

image.png



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !