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

     

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

 

arifulice09's avatar
arifulice09
Helper I
4 years ago

goncalogeraldes Thanks for your reply, using the above code only giving the result of "Fixed" value.