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,
The actual dateskey in my table is 202007, which are the year and the mont of the current date.
From that date, I would like to add 25 months which will give me my second date. I easy to do that with key measure.
My question is how can we use key measures such as date1 and date2 to limit the quantity of date show in a matrix base on the transaction date, i.e. if trasactiondate between date1 and date2 show the data into the matrix otherwise, filter them.
HI @Anonymous,
Perhaps measure filter on visual level may suitable for your requirements, you can take a look at the below blog to know more about this.
Applying a measure filter in Power BI
If you confused about coding formula, please share some dummy data with a similar data structure and the expected output that you wanted.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
@Anonymous , For from this from at you can create a date and then join with date table
202007
date = Date(left([Monthyear],4),right([Monthyear],2),1)
then you can use time intelligence
Power BI — MTD Questions — Time Intelligence 3–5
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
Dateadd ot date to get 25 month back date
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
Appreciate your Kudos.
Hi @Anonymous ,
Please share some sample data and then explain your issue. This is really hard to understand what you are asking here.
Thanks,
Pragati
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
71 | |
39 | |
27 | |
27 |
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |