Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Availability rate

Hi All,

 

I have fTE/month, for few month it has no value and for few it has value.

I have the data from 2016 jan till march 2018.

I need to calculate a measure where i need percentage calculation.

1-(FTE,Month / 4023)

when there is no value which is 0 then it will divide by 4023 and gives "0".

Later it is sub by 1 gives 100% percentage.

my concern here, i dont have values for my future data which is april 2018 and above but it is giving 100%.

Where i dont need my future data to be shown because it doest have any values(Not updated)

 

In this case how can i slove this issue.

 

Kindly suggest!

 

Thanks:)

 

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    Can you share a sample please? The solution could be using function "IF".

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi v-jiascu-msft,

       

      Thanks for you effort,

       

      Below is the screenshot of the data,

      I have FTE for each month starting from Jan 2016 - April 2018, But when i upload it in power BI its giving the value for future month as well which is not updated at all.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi Anonymous,

         

        What's your formula? It could be something wrong with your formula.

         

        Best Regards,

        Dale