Forum Discussion

Rusciano's avatar
Rusciano
Frequent Visitor
3 years ago

Collecting each refresh date.time in a table

Hi Community,   I am about losing my head to solve the following issue. It would be very easy for members which usually use Power.Query but not for me that a never do it before (I have always used ...
Need Help
ONGCHEESENG's avatar
ONGCHEESENG
New Member
1 year ago

Hi,

 

Achieved the same goal. But by using Power Query in Excel. May be inspired you and happened in your Power BI as well.

 

https://youtube.com/shorts/V2ut7MnvNCo?feature=share 

 

BR

ONG CHEE SENG

//M Codes
let
    Source = List.RemoveNulls(Excel.CurrentWorkbook(){[Name="Table1_1"]}[Content][Refresh Date n Time]&{DateTime.LocalNow()}),
    Custom1 = #table(type table [Refresh Date n Time=datetime], List.Transform(Source, each {DateTime.From(_)}))
in
    Custom1