date filtetr

[Anonymous]

Hi All,

I have data from Jan 2016 to July 2019.

i want to give date filter as drop down(not relative filter).  if my partner or client select Feb 2019, i want my chat or table to reflect from Jan 2016 to feb 2019. basically my end date should be feb 2019. 

please do let me know if i can experiment some solution.

[kevderbeste]

Hi @Anonymous try converting your value colum in a measure with TOTALYTD.

Example: is ur columna value is Sales, create a measure with this TOTALYTD(SUM(SALES), calendartable.[date])

This do that the measure have a behavior based in dates, and the char take this beahvior automatically.

Thanks and regards! 

[Anonymous]

Hi @kevderbeste 

This didn't work at my requirement.

can i create a measure where if my filter field is June 2019 then i need to 1 in my calender table and similar way it should follow in desc.

Example :-

June 2019 - 1

may 2019 -2

april 2019 -3

[kevderbeste]

Hi @Anonymous  u need a calendar table, autogenerate in power bi, in order to have compatibility, u can generate one with Calendar_table = CALENDARAUTO(), this make a table with one column called date, and with this u can create all the columns tht you need, like year, month... 

Searching the format  2019 JANUARY u have the dax below.

Year-Mon = FORMAT('Calendar_table '[Date], "YYYY-MM")

[Anonymous]

hi,

Thank you so much for your reply. i will try this and get back to you on ASAP.

Regards,

Nagesh