Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

New Data Value Alert

I am working with  a column whose domain can change and I need to provide explicit support for these. As an example, suppose a column contains a set of Strings {"Good", "Bad", "Ugly"} and I will crea...
Show and Tell
  • nickchobotar's avatar
    nickchobotar
    8 years ago

    Anonymous

     

    The easiest way to do this is to create a new query and reference only that field from your data table you want to keep an eye on, turn it into a list and get a count on it.   (Preferred way is to set this up inside your server environment )

     

    Create a new query and bring in the field you need as a list.

     

     

    let
        Source = Table1[Column1],
        Custom1 = List.Count(Source)
    in
        Custom1

     

     

     

    Close and save power query and bring your count into the report view. So, once new value gets added up to your dataset , you will see this immediately reflected in your report.



v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Have you tried the solution provided by nickchobotar above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

 

If you still have any question on this issue, feel free to post here. :smileyhappy:

 

Regards

asc002's avatar
asc002
Frequent Visitor
8 years ago

HI,

I am pretty new on this, so would it be possible to have little more information on how to do it?

 

I have a table name table1 with several columns and several values. I would like to make a data alert when a new record is added to the table1 for the column1 but only for a specific value (e.g. column1 contains two values like "blue" and "red" and I want to know only a new record for "blue").

 

How can I build a KPI on it in order to be able to set a data alert that notify me when a new value is added?

 

thanks

ANdrea