Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all
I need to create a YTD slicer button
is it possible in DAX without attaching any measure ?
if so i'd like to know how
thanks !
HI @JosefPrakljacic -
How can I calculate YTD into a new column in a Date table ?
I have a slicer panel that contains date slicers such a ALL TIME , LAST 7 DAYS , LAST 30 DAYS , and a DATE RANGE - all in a separated chicletslicer buttons .
Also , today , for YTD button I use a fillter on 2019 and i want to replace it with a set formula so i wont have to change the year manualy each january ...
it looks like this - YTD
2019
Hey @Anonymous,
would you please give us an example of your expected result?
What is a "slicer button"?
And I would say that you are going to need DAX but till I don't know what a "YTD Slicer Button" is - its just a big guessing game.
Hint: Its not a shame to also provide some sample data - just sayin 🙂
BR,
Josef
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
25 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |