Forum Discussion

Domingos's avatar
Domingos
New Member
3 years ago
Solved

formula on power query

Hi comunity,

How do I rewrite the following formula created on Data view in power query ?

Nº de CM por RO = CALCULATE(COUNTA(Planeamento[Consulta de mercado]),
FILTER('Estados_Uniques','Estados_Uniques'[Consulta de mercado]='Estados_Uniques'[Consulta de mercado]))

Thanks
Need Help
  • AjithPrasath's avatar
    AjithPrasath
    3 years ago

    Domingos ,

      Hi, Please use the below code in custom column:

    Nº de CM por RO = 
let
    consultaDeMercado = [Consulta de mercado],
    estadosUniques = Table.SelectRows(Estados_Uniques, each [Consulta de mercado] = consultaDeMercado),
    count = Table.RowCount(estadosUniques)
in
    count

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

2 Replies

  • AjithPrasath's avatar
    AjithPrasath
    Resolver II
    3 years ago

    Domingos ,

      Hi, Please use the below code in custom column:

    Nº de CM por RO = 
let
    consultaDeMercado = [Consulta de mercado],
    estadosUniques = Table.SelectRows(Estados_Uniques, each [Consulta de mercado] = consultaDeMercado),
    count = Table.RowCount(estadosUniques)
in
    count

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍