Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

If condition

Hi I am trying to make a condition: If column month>=month(now);sum(X);sum(y) The problem is that when I make the condition I can only put measures and functions. I don't have the option to referen...
Need Help
Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

 

Basically Measurs dont work with row context so you need to use MAX or MIN, something like below.

If MAX(column month )> = MONTH( TODAY() );sum(X);sum(y)


Please read the article below for more info.

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

 

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Mariusz 

     

    I try 

    Valor total = if(MAX(Doc_Factura[Mês])>=MONTH(TODAY());[Facturação Bruta];[SumValorPub])
     
    but I keep receiving the error:
     

    "Dax comparison operations do not support comparing values of type text with values of type integer."

     

    Doc_Factura[Mês],month(today()), Facturação bruta; sumValorPub are integers and decimals  so I don't understand the error.

    I try to make a new column with funtion value but the error was the same

    IF(VALUE(MONTH(Doc_Factura[data_doc_df]))<=VALUE(MONTH(TODAY()));[Facturação Bruta];[SumValorPub])
    • Cmcmahan's avatar
      Cmcmahan
      Resident Rockstar
      7 years ago

      Check your tables.  Make sure that PBI recognizes that Doc_Factura[Mes] is an integer value and not a string.

      Otherwise, using VALUE should have worked to force a type change.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I already check and it is a integer, that's why I don't understand the error..even if it wasn't the value function should change the type to integer.