Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • BobBI's avatar
    BobBI
    7 years ago

    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

  • PattemManohar's avatar
    PattemManohar
    7 years ago

    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))

BobBI's avatar
BobBI
Resolver III
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Hi Dynamic date,

 

That helped with the current database that I have. But in case where I dont have a date column and I need to create one, this solution wouldnt be helpful. If you have anything around creating a fresh date column lemme know.

 

Thanks