Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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!
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
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")
hi,
Thank you so much for your reply. i will try this and get back to you on ASAP.
Regards,
Nagesh
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |