vishalpat13
New Member
- Joined
- Mar 11, 2022
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hi Team,
So, I have a power Bi task at hand where I have created a dashboard . Issue is I need to display average of a calculated column by month
for eg; I have a column with name CSM readiness
CSM readiness = csm1 + csm 2
-----------------------------------------------------------------
Campaign Id CSM readiness
123 7
456 6
321 8
789 9
003 3
Presented above is an example where you can consider CSM readiness as the calculated column
Now, for different Ids, I am getting this value while I put slicer as filter for month
So, Please help me in getting the average of this CSM readiness column while indicating USE Relationship also because month is a part of inactive relationship
So, I have a power Bi task at hand where I have created a dashboard . Issue is I need to display average of a calculated column by month
for eg; I have a column with name CSM readiness
CSM readiness = csm1 + csm 2
-----------------------------------------------------------------
Campaign Id CSM readiness
123 7
456 6
321 8
789 9
003 3
Presented above is an example where you can consider CSM readiness as the calculated column
Now, for different Ids, I am getting this value while I put slicer as filter for month
So, Please help me in getting the average of this CSM readiness column while indicating USE Relationship also because month is a part of inactive relationship