Forum Discussion
Reporting Performance to Target
I managed to do it. Please see below:
1. I created calculated column only for my past due balances.
2. After that another one I named "Fraction of the Overdue" with few nested ifs. If month =9 then overdue column * 0.055, if month = 10 then overdue column * 0.05 etc.
3. I created 3rd column dividing the Fraction of the Overdue to the Overdue column.
4. Put it in the pivot table, but summerizing the value to Average
5. Done.
This is how my pivot looks now. Exactly as I wanted it.
negi007 I would really want to thank you for your guidance and support.
Wish you nothing but the best.
Take care and stay safe.
All due respect,
Atanas
Anonymous You can get option to "Analyze in excel" in power bi services as well. Once you have published the databoard on the powerbi services, you get the option to "Analyze in excel", it remains connected to your dataset.
Refer to this link for help
I managed to do it. Please see below:
1. I created calculated column only for my past due balances.
2. After that another one I named "Fraction of the Overdue" with few nested ifs. If month =9 then overdue column * 0.055, if month = 10 then overdue column * 0.05 etc.
3. I created 3rd column dividing the Fraction of the Overdue to the Overdue column.
4. Put it in the pivot table, but summerizing the value to Average
5. Done.
This is how my pivot looks now. Exactly as I wanted it.
negi007 I would really want to thank you for your guidance and support.
Wish you nothing but the best.
Take care and stay safe.
All due respect,
Atanas