Get the maximum data

[icdns]

Hello, 

Would like to ask for your help in displaying the MAXIMUM data to be displayed as the line in my visual. 

I want my "Actual Availability" to display the latest data which is April 2020. No Date filter are applied here. 

Table Name: Table1

My columns are: 

• Services
• Date
• Availability

Output: My line should display the latest data which is April 2020 values. 

Thank you! 

[amitchandak]

@icdns ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share the formula you used

Can you share sample data and sample output in table format?
Appreciate your Kudos.

[icdns]

I have my columns: (Date, Service, Availability). Would need your help in displaying April 2020 data as my Actual_Availability%.

[pranit828 · Accepted solution]

Hi @icdns 

Create a measure 

max_data = CALCULATE(MAX(table[Availability],Allexcept(table,table[Services]))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Regards,
Pranit

[icdns]

Hi Sir, 

It displays an error: 

😞