Forum Discussion
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...
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.
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.