Forum Discussion
year to date
Hi JP-Ronse,
To use the solution suggested by WolfBiber, you need to create a calendar table first, and create a one to many relationship between calendar table and your source table.
DateTime=CALENDAR(DATE(2015,1,1), DATE(2018,12,31))
By the way, all above functions are DAX functions which should be used in report view mode rather than Query Editor mode.
Regards,
Yuliana Gu
;) then use PowerBi Desktop, its for free
https://powerbi.microsoft.com/en-us/desktop/
and you can create date Tables in Excel 2016, don't know if in 2013 its also working
JP-Ronse You can create calendar table in PQ as well, here is link for that , I'm sure there are more.
https://www.powerquery.training/portfolio/dynamic-calendar-table/
Hi,
Thanks for the swift reply, I have
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"DAY", type datetime}, {"THRESHOLD", Int64.Type}, {"MIN_OCCURENCES", Int64.Type}, {"METRIC", type text}, {"RESOURCE_NAME", type text}, {"CONT_BREACHING_COUNT", Int64.Type}, {"SEPARATED_BREACHING_COUNT", Int64.Type}, {"islast<I1>months", type any}, {"12", type any}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each DATESINPERIOD([DAY],DATE(2018,01,03),-12,month))
in
#"Filtered Rows"But it says: The name 'DATESINPERIOD' wasn't recognized.
Secondly, the todays date should be adapted automatically.
(I am a new, sorry for all the stupid questions)
I am using Excel 2013 with PQ add-in.
Kind regards,
JP