Forum Discussion

arifulice09's avatar
arifulice09
Helper I
4 years ago
Solved

Power BI calculated column Help

I have a data table (see the attached) , I am trying to get a calculated column based on some condition 

Condition( if all FeeType is Hourly for a particular project then for that project the result will be Hourly, if all is NoBilling then NoBilling else Fixed) but I am not getting the result.

 

Need Help
Show and Tell
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi arifulice09 ,

     

    Create a column like this:-

    Column_ = 
var _hourly = COUNTROWS(FILTER('Table (3)','Table (3)'[Feetype] = "Hourly" && 'Table (3)'[projectid] = EARLIER('Table (3)'[projectid])))

var _nobill = COUNTROWS(FILTER('Table (3)','Table (3)'[Feetype] = "NoBilling" && 'Table (3)'[projectid] = EARLIER('Table (3)'[projectid])))

var _proj = COUNTROWS(FILTER('Table (3)','Table (3)'[projectid] = EARLIER('Table (3)'[projectid])))

return SWITCH(TRUE(),
_hourly = _proj  ,"Hourly",
 _nobill = _proj,"No Biling",
"Fixed")

    Output:-

     

    Thanks,

    Samarth

     

4 Replies

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    Hi arifulice09 ,

     

    Create a column like this:-

    Column_ = 
var _hourly = COUNTROWS(FILTER('Table (3)','Table (3)'[Feetype] = "Hourly" && 'Table (3)'[projectid] = EARLIER('Table (3)'[projectid])))

var _nobill = COUNTROWS(FILTER('Table (3)','Table (3)'[Feetype] = "NoBilling" && 'Table (3)'[projectid] = EARLIER('Table (3)'[projectid])))

var _proj = COUNTROWS(FILTER('Table (3)','Table (3)'[projectid] = EARLIER('Table (3)'[projectid])))

return SWITCH(TRUE(),
_hourly = _proj  ,"Hourly",
 _nobill = _proj,"No Biling",
"Fixed")

    Output:-

     

    Thanks,

    Samarth

     

  • goncalogeraldes's avatar
    goncalogeraldes
    Super User
    4 years ago

    Hello there arifulice09 ! Check if this works for you:

    Desired Result =
SWITCH (
    TRUE (),
    DISTINCTCOUNT ( 'Table'[Feetype] ) > 1, "Fixed",
    SELECTEDVALUE ( 'Table'[Feetype] )
)

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
    Thanks!

    You can also check out my LinkedIn!

    Best regards,
    Gonçalo Geraldes