Forum Discussion
New Data Value Alert
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
Custom1Close 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.
Skilled SharerAnonymous
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.