Announcement

Collapse
No announcement yet.

Power Query & Countif

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Power Query & Countif



    I had a formula in a table in excel =IF([@STATUS]="",[KEY]&"_"&COUNTIF(INDEX([KEY],1):[@KEY],[@KEY]),""), which showed me how often a value showed in the data. But the same is not working in Power Query

    with the formula I use to get if the same value's position in a long data list, and then I use the same in index match formula to find and locate other relevant data

    I got data in number of files.. and I want create a dashboard with this data in another file which is macro enabled..

    as I get the data from number of files to the dashboard, excel is making me use Power Query to link data.. once the data is linked it becomes a table and I have to add a new column with formula to get the information I need... Plus I can't add the column in raw data files, as they are just downloaded from number of different systems and want users to not worry about formula's and stuff when they get the raw data.. hope I was able to explain my dilemma.

  • #2


    Hello,

    You might be interested in following link :

    http://jaykilleen.com/posts/countif-...ing-m-language

    Hope this will help
    If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

    Comment

    Working...
    X