Forum Discussion

WSMikey's avatar
WSMikey
New Member
4 years ago

Operand Type Null Error

Hi Everyone, I'm pretty new to PowerBI & SQL, but learning lots and enjoying it! I have a problem with my calculated column below.    Current_Period_Budget = VAR Period = [SelectedMonth] RETURN ...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

WSMikey ,where is sum here ?

 

Try like

 

Current_Period_Budget =
VAR Period = month(maxx(allselected('Date'), 'Date'[date])
RETURN
if(RELATED(GLAMF[ACCTBAL]) = "2", -1,1) *
Switch(Period,
9,GLAFS[NETPERD1],
10,GLAFS[NETPERD2],
11,GLAFS[NETPERD3],
12,GLAFS[NETPERD4],
1,GLAFS[NETPERD5],
2,GLAFS[NETPERD6],
3,GLAFS[NETPERD7],
4,GLAFS[NETPERD8],
5,GLAFS[NETPERD9],
6,GLAFS[NETPERD10],
7,GLAFS[NETPERD11],
8,GLAFS[NETPERD12])

  • WSMikey's avatar
    WSMikey
    New Member
    4 years ago

    Hi amitchandak , thank you for the quick response!

     

    I was wondering the same thing about the Sum - It is not in the formula. The only think i could think of is that somehow, since i am using Direct Query to the SQL DB, it was arising from there. 

     

    I tried the solution above, and variations of it, however, MAXX is not understood in the formula bar. Note - i'm creating the column directly in the PowerBI interface as opposed to Power Query editor - if that matters.