Forum Discussion

zoupie's avatar
zoupie
New Member
6 years ago
Solved

need help with calculation

We want to calculate the % completed each month and use this value in the line value of a combination bar and line chart.  I only see the option to show the % of grand total in the quick measures.  N...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi zoupie ,

     

    Check the document about how to create calculated column.

    https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

    In addition, I don't quite understand what your mean "This is more of the downsteam table".

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi zoupie ,

 

Create a calculated column yearmonth as x-axis.

yearmonth = FORMAT('Table'[SO_START_DATE],"YYYYMM")

Create measure as below.

Measure = CALCULATE(SUM('Table'[SO_JOB_SEQ]),FILTER(ALLEXCEPT('Table','Table'[yearmonth]),'Table'[SO_STATUS_NAME]="FINISHED"))/CALCULATE(SUM('Table'[SO_JOB_SEQ]),ALLEXCEPT('Table','Table'[yearmonth]))

Check if the result is what you want.

If not, let me know.

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

zoupie's avatar
zoupie
New Member
6 years ago

sorry new to this formula builder.  I am trying yearmonth.  not working

 

yearmonth = FORMAT('vw_datamart_Activities'[dt_start],"YYYYMM")

This is more of the downsteam table

feel free to adjust our dashboard.  AppWorx_Azure

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi zoupie ,

     

    Check the document about how to create calculated column.

    https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

    In addition, I don't quite understand what your mean "This is more of the downsteam table".

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.