cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nageshshastry1 Regular Visitor
Regular Visitor

date filtetr

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.

4 REPLIES 4
kevderbeste Regular Visitor
Regular Visitor

Re: date filtetr

Hi @Nageshshastry1 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! 

Nageshshastry1 Regular Visitor
Regular Visitor

Re: date filtetr

hi,

 

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

 

Regards,

Nagesh

Nageshshastry1 Regular Visitor
Regular Visitor

Re: date filtetr

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 Regular Visitor
Regular Visitor

Re: date filtetr

Hi @Nageshshastry1  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")

 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 339 members 2,803 guests
Please welcome our newest community members: