Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Output Status as Column

Hi All,   In the below table for the first week I worked 40 hours out of 40 so it is billable. Second week same as first week. So for 1st and 2nd week i am Billable. But for third week i worked on...
Need Help
hthota's avatar
hthota
Icon for Resolver III rankResolver III
7 years ago

Hi 

 

Create a column as given below.

Column 2 = IF(Table1[Column]="Partially Billable",1,0)
 
And Place it in a card. Change the Sum.
 
Thanks,
Hemanth
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Thanks for your respose.

     

    I tried your suggestion but its not working.

    Let me re iterate the thing.

     

    In the below screenshot

    if i select may 16 in date then status should show as Billable i.e.,Billable count = 1 and partially Billable =0

    if i select may 9 in date then status should show as PB i.e.,Billable count = 0 and partially Billable =1

    if i select may 23 in date then status should show as PB i.e.,Billable count = 0 and partially Billable =1

    if i select may 16 and may 9 both in date then  it is 70 hours out of 80 then status should show as partially Billable i.e.,Billable count = 0 and partially Billable =1

     

    Thanks in Advance

    • v-lili6-msft's avatar
      v-lili6-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      HI, Anonymous 

      You could just create a measure instead of [Cstatus] column.

      Measure =
IF (
    DIVIDE (
        CALCULATE ( SUM ( 'Table'[Billing Hours] ) ),
        CALCULATE ( SUM ( 'Table'[HoursForWeek] ) )
    ) < 1,
    "PB",
    "Billable"
)

      Result:

       

      here is pbix file, please try it.

       

      Best Regards,

      Lin

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi v-lili6-msft ,

         

        Thanks for your respose. It is working as expected but i want that as column because I would like to see that in Pie Chart.

         

        Regards,

        Prakash