Is it possible to use key measure to filter the data in matrix or a table

[Anonymous]

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.

[Anonymous]

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

[amitchandak]

@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

https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power-BI-Turning/ba-p/1187827

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.

[Pragati11]

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