IF statement in table using measures,

[KH11NDR]

Hi Guys,

What I'm trying to do as a measure to work in a table and probably charts too.

=IF(Month >= Month(Today()), Year = Year(Today()), 'Show Measure with new calculated figures','show historic sales' (Sales)

So

Jun                    :    Jul                    :             Aug

10                     :   15                       :      20

Sales field         : Sales Field             :     Calculated measure.

Thanks  

[KH11NDR · Accepted solution]

I gave up waiting and worked it out lol, just need to add the Year bit in, which i'll sort out easily.

Measure 3 = if([Measure 2]>= MONTH(TODAY()),[Measure 2],[Measure 4])

[tex628]

Measure = 
IF([Month]>MONTH(TODAY()) && [Year]=YEAR(TODAY());
[Calculated measure];
[Historic sales]
)