Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Creating new table with min values from another table

Dear everyone,   I have problems filtering the values for my new table. I have a table with a lot of forecasts per customer; a date when the forecast was made, a date when forecast is valid, value...
Need Help
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    You can new a calculated table like this:

    New Table =
SUMMARIZE (
    table,
    table[custid],
    table[issued(LT)],
    table[valid(LT)],
    "Min diff", MIN ( table[diff issued/valid] )
)


    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

 

You can new a calculated table like this:

New Table =
SUMMARIZE (
    table,
    table[custid],
    table[issued(LT)],
    table[valid(LT)],
    "Min diff", MIN ( table[diff issued/valid] )
)


Best regards,

Yuliana Gu