Measure - Showing values (or not) depending on if in current month

[Anonymous]

Hello Community  - 

I am getting an error message in my measure below saying that my true/false statement does not specify a column.  But it does, I think?    Need help on getting a measure to work based on this:  

The goal of this formula is to use the VAR measures below in a table.    Our NetRevenueFinal would be the official number after accounting closes the month...at that point nothing else should show up in that month's column.   The other months would show booked orders (ERP), and our forecasted amounts for those months.  But would not show NetRevenueFinal  (since we don't know what that is yet).    So, I have a true/false column in my date table that says if the month is completed, true, otherwise false.   Well, January is completed, so the table below is basically what I am trying to achieve with my measure below.  

Measure Value	Jan	Feb
NetRevenueFinal	10,000
ERP		25,000
Total Forecast		10,000

Revenue Table_Graph =

VAR _ERP = [Order Value]

VAR _TotalForecast = [50% Prob Total] + [60 70 80% Prob Total]

VAR _NetRevenueFinal = [Sum of Net Revenue]

RETURN

CALCULATE([Sum of Net Revenue],'Dim_Date Table'[MonthCompleted] = TRUE(),_NetRevenueFinal,_erp + _TotalForecast

)

[v-janeyg-msft]

Hello @Anonymous 

Any updates? Do you still need help?

[Anonymous]

@lbendlin   I tried that before, but the issue I'm having is that intellisense won't allow me to use 'Dim_Date Table'[MonthCompleted]  in the formula  

[v-janeyg-msft]

Hi, @Anonymous 

So [MonthCompleted] is a measure not column? Can you share some sample data and your measures? We need more details to see how to modify.

Janey

[lbendlin]

You probably need something like 

Revenue Table_Graph =

VAR _ERP = [Order Value]

VAR _TotalForecast = [50% Prob Total] + [60 70 80% Prob Total]

VAR _NetRevenueFinal = [Sum of Net Revenue]

RETURN

IF('Dim_Date Table'[MonthCompleted],_NetRevenueFinal,_erp + _TotalForecast)