Getting max date based

[Gangasaniravi]

Hi All,

I want to display only maximum date value if you have other columns in visual.

customer Name	Date	Balance	bucket
Customer 1	30-Nov-22	45	0-30
Customer 1	31-Oct-22	50	31-40
Customer 1	31-Dec-22	23	41-60

I want to show max date, if select November and December months in slicer I want to see only December data and if I select October and November I need to see only November data.

output

customer Name	Date	Balance	bucket
Customer 1	31-Dec-22	23	41-60

[Gangasaniravi]

@Anonymous  Thank you for the help, Here i am getting balance based on top selection. let say if i select top 2 then i need to get 2 customers first then if i select all months in slicer in visual i need to see december only.Below is the logic for

top Balance =

VAR customerrank = RANKX(FILTER(ALLSELECTED(customercustomername]), [Balance] <> BLANK()), [Balance],,DESC)

VAR balance = IF(customerrank<= SELECTEDVALUE('Custimer_rank'[Rank]), [Balance])

Return balance

[Anonymous]

Hi, @Gangasaniravi 

Based on your information, I create a table

You want to show max date, use following DAX:

MaxDate = IF(MAX('Table'[Date])=MAXX(ALLSELECTED('Table'),'Table'[Date]),1)

If you select November and December in the slicer, this will show data for December.

And if you select October and November, it will show data for November

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...