Error while using time intelligence function

[Anonymous]

Hi All,

  I am facing below error while using any of the time intelligence function.

Date [Date] column contains all  dates of model i.e.calender(date(2017,1,1),date(2019,1,1))

Any help would be appreciated.

[v-yuta-msft]

@Anonymous ,

Click "New Table" instead of "New Column".

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yuta-msft, @v-cherch-msft Hi Thank you  for your suggestion.

Date table is already created and model is bit complex.Basically I want create dynamic slicer which will show data for one year considering 1st of that particular month.

I have used relative slicer but when applied for 1 year it shows date like 20/2/2018-20/2/2019

But I want it to show from 1/2/2018-20/2/2019

  start date should change dynamically to 01/month/year for slicer.

[v-yuta-msft]

@Anonymous ,

So your requirement is to create a dynamic table based on the date slicer? If it is, I'm afraid power bi doesn't support dynamic table or column. You can use measure instead using DAX function like ALLSELECTED() in your specific senario.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yuta-msft 

Not table exactly.But yes dynamic date slicer,where start date =current month and end date=month of last year which should  start with 1st of that month  always

eg. It should show me data between 

Today(05 apr 2019 t) to last year( 01 apr 2018)

Any suggestion on DAX  query/function.

Thank you in advance.

[Anonymous]

@Anonymous,

PARALLELPERIOD returns a table, normally used in the filter arguements of CALCULATE statement. In your case you might want to try DATEADD for your calculated column