Forum Discussion
Solved
Hekp with M Query
Hi, I am trying to retrieve data into one of the query in power query editor using M for last 18 months,but below query retrieves 2 years of data. Can you please let me know the formula to ...
Below query worked for me as per my requirement,to retrieve data for last 18 months,
As I also need a number format not a date format.
Hi
Anonymous
Data Type of the [PE_Date_Int] column is integer(number) not a date,How can i cast/convert below function accordingly because when i use below one the data refresh is taking forever,because of comparison between number and date.
= Date.AddMonths( Date.StartOfMonth( DateTime.LocalNow() ) , -18)
Thanks..
= Number.From(Date.ToText(Date.AddMonths( Date.StartOfMonth( DateTime.LocalNow() ) , -18),"yyyyMMdd"))
Below query worked for me as per my requirement,to retrieve data for last 18 months,
As I also need a number format not a date format.