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','Est...
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 👍

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 👍