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. 

      • Cmcmahan's avatar
        Cmcmahan
        Resident Rockstar
        7 years ago

        It should, which is why we get to debug this to figure out what's happening.

         

        I know it's obnoxious, but can you make a few new measures, to show what value is being returned at each step?

        Test1 = MAX(Doc_Factura[Mês])
        Test2 = MONTH(TODAY())
        Test3 = [Test1]>=[Test2]
        Test4 = [Facturação Bruta]
        Test5 = [ValorSumPub]

        Hopefully when you put these into a table, all the results make sense, but if there's one that doesn't work properly, we can focus in on that one.  As of right now, I have no idea where your problem is. It all looks like it should work.