Forum Discussion
Solved
Updating data source by replacing Outlook attachment
Hi! This may be an amateur's question (which I am, have started recently...), but for me it is tricky: I have a scheduled report sent to me by e-mail, from which I only need the Excel attachment....
Hi,
In your dataset, I am assuming that there is a column which represents "Date of Attachment" or Date of Mail". In the Query Editor, write this "M" language formula to get today's date in a column
=DateTime.Date(DateTime.LocalNow())
In "M" itself, write this formula to check for whether the Date of Attachment is the same as Today's date
=[Date of Attachment]=[Today]
Today is the name of column with Today's date. Filter this new column on TRUE.
Hope this helps.
After banging my head a little, I found what I was looking for – which is to keep only the latest e-mail: I just had to use the option "Keep Rows" and select 1, so out of the incoming e-mails flow, Power BI will only stick to the last one received.
But thank you very much for your time, Ashish!
You are welcome.