How do we bring Max and Min date values alone in Matrix visual in runtime user selection?

[Nareshbaabu]

Hi 

I want to create a Matrix visual which should restrict with min and max date values. Let me know how to we acheive this in PowerBI

[Nareshbaabu · Accepted solution]

@Anonymous

I got a requirement from client like. It'll have date column, Acc No, Amount. 

User will select the two dates from Date slicer. And Matrix or Table visual will display values only for those dates. It'll have Max and Min date of selected between date.

I've created a expression to overcome this.

Got the solution by doing few work arounds.

Thanks for your replies guys.

@Anonymous @v-chuncz-msft

[Anonymous]

Dear @Nareshbaabu,

Can you tell me more about your purpose? I can help your problem, if I know min,max for Axis Or filter a measure or just for your Filter Slicer?

Regards,

ManNVSM.

[Nareshbaabu · Accepted solution]

@Anonymous

I got a requirement from client like. It'll have date column, Acc No, Amount. 

User will select the two dates from Date slicer. And Matrix or Table visual will display values only for those dates. It'll have Max and Min date of selected between date.

I've created a expression to overcome this.

Got the solution by doing few work arounds.

Thanks for your replies guys.

@Anonymous @v-chuncz-msft

[v-chuncz-msft]

@Nareshbaabu,

A slicer is enough. You may check the following link.

https://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373

[Nareshbaabu]

@v-chuncz-msft thanks. I"ve used Max and Min expression to calculate my requirement. And got the solution.

[v-chuncz-msft · Accepted solution]

@Nareshbaabu,

Glad to hear that. By the way, to help close this thread, you may accept solution. Your contribution is highly appreciated.