Forum Discussion

melina's avatar
melina
Icon for Helper IV rankHelper IV
9 years ago
Solved

set maximum data row in table

Hi All,   I have used table visualization for Vendor details data. The problem is when too much data. Then the table need to scroll down. I dont want my user to scroll the data because this project...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    melina

     

    In DAX, table has no sequence for records internally. To get the maximum row, you must be based on a column like Index or Date. Then you can create a calculated table like below:

     

    Table 2 = FILTER(ALL('Calendar'),'Calendar'[Date]=MAX('Calendar'[Date]))

     

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

melina

 

In DAX, table has no sequence for records internally. To get the maximum row, you must be based on a column like Index or Date. Then you can create a calculated table like below:

 

Table 2 = FILTER(ALL('Calendar'),'Calendar'[Date]=MAX('Calendar'[Date]))

 

 

Regards,