Greetings!
I've searching and struggling for creating a measure column based on other measure columns.
For your reference I've attached both the PBI and Excel.
I was able to achieve the below :
1. Created 2 different Measure to get count of Negative and Positive, as per year and month (Positive and Negative count column in PBI report)
2. Created 2nd Measure to get sum of only Negative option
3. Created a 3rd Measure named as Average and added below formula :
Average = DIVIDE([Spend / Month],[Positive and Negative Count])
In Excel - into 7-2 and 7-3 tabs, I'm looking for the same values (column G and H) which should get updated to Power BI report in table.
I looked for various searches but could not get the desired output.
Column F in both the tabs, are the manual values that we update start of every year through last month.
Let me know if more explanation is required.
Thanks,
Prakash
I've searching and struggling for creating a measure column based on other measure columns.
For your reference I've attached both the PBI and Excel.
I was able to achieve the below :
1. Created 2 different Measure to get count of Negative and Positive, as per year and month (Positive and Negative count column in PBI report)
2. Created 2nd Measure to get sum of only Negative option
3. Created a 3rd Measure named as Average and added below formula :
Average = DIVIDE([Spend / Month],[Positive and Negative Count])
In Excel - into 7-2 and 7-3 tabs, I'm looking for the same values (column G and H) which should get updated to Power BI report in table.
I looked for various searches but could not get the desired output.
Column F in both the tabs, are the manual values that we update start of every year through last month.
Let me know if more explanation is required.
Thanks,
Prakash