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?
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.