Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello
I have a segmentation filter which I have put a filter on so that it comes out on the day we are, so good. The thing is, I'd like to put the start date a year ago and the end date today.
For the filter I have the following column:
Fecha Actual = IF(CALENDARIO[Date] = TODAY(),"si","no")
This changes both the initial and the final for me.
Is there a way to do it?
Thank you.
Solved! Go to Solution.
Hi @apenaranda ,
You can use relative date slicer to achieve it just as shown in the below screenshot:
Create a relative date slicer or filter in Power BI - Power BI | Microsoft Learn
Best Regards
You can make use of my DAX Calendar that has offset-columns for days, weeks, months, quarters and years from today for any kind of relative date filtering!
Set Year days offset between -365 and 0 for the last rolling year.
You'll find it here:
https://www.villezekeviking.com/dax-tables-calendar-and-time/
Hi @apenaranda ,
You can use relative date slicer to achieve it just as shown in the below screenshot:
Create a relative date slicer or filter in Power BI - Power BI | Microsoft Learn
Best Regards
StartDate = DATEADD( DateField, -1, year)
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
72 | |
70 | |
37 | |
29 | |
26 |
User | Count |
---|---|
91 | |
49 | |
44 | |
38 | |
37 |