New Data Value Alert

[shhafiz]

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 create a column based of this column to give numerical scale {1,2,3}, using if conditions. I understand there is a generic way to do this mapping, but this is just an example and for my actual case I need to provide hard coded support.

I need a way to be notifed that a new value, say "Superb" has been added to a row after a data refresh so I can provide necessary support. 

Thanks.

[v-ljerr-msft]

Hi @shhafiz,

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. 

Regards

[asc002]

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

[nickchobotar · Accepted solution]

@shhafiz

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.