Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Twice max value present

Hello Team,
In below image as you see i have twice max value wanted to show MAX value to single data row not 2 data row.
Need help to update it with one data row with MAX value. 

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but one of the ways to have summarized table is by removing duplicate values in Power Query Editor.

    However, if you cannot go into the Power Query Editor to transform tables, please try the below by creating a new table by using DAX.

    Please check the attached pbix file. It is for creating a new table.

     

    New Table = 
SUMMARIZE( Data,Data[Last month],Data[Max value])