Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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