Forum Discussion
dynamic date
Hi, I need a date table that has only the last dates of every month. Like the one below. (I wanted to create a parameter for period end date but that function doesn't seem to be available in power B...
You can do this in Edit query mode. Here below are the screen shots.
and then right click on the Date header --> Remove duplicate , this will give you one row for each month as last day of the month.
Hope this helps,
SS
Anonymous Another way of doing this is.. Using "New Table" option with DAX below
_DimDateEOM = FILTER(CALENDAR("01-01-2018","31-12-2018"),[Date]=EOMONTH([Date],0))
Anonymous Another way of doing this is.. Using "New Table" option with DAX below
_DimDateEOM = FILTER(CALENDAR("01-01-2018","31-12-2018"),[Date]=EOMONTH([Date],0))Hi Pattemmanohar,
This was helpful.
Thanks!