Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with Measure

Hi All,   Need some help with writing a measure for the below scenario.   I want the average of the values to be assigned to the end of the month.   If there are no values for a certain month, ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    In the previous table I set the Value of Altona North and Armadale to be the same as Alexandria to save time, so there will be no change when filtering.

     

    I have adjusted the data, please download the latest attachment.

     

    Best Regards,

    Community Support Team _Charlotte

    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
4 years ago

Hi v-zhangti,

 

The table seems to be working fine. However, the line graph does not seem to update with filter selection.

 

Would you be help (hopefully for the last time!)

 

Again, appreciate your help so much!

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, Anonymous 

 

In the previous table I set the Value of Altona North and Armadale to be the same as Alexandria to save time, so there will be no change when filtering.

 

I have adjusted the data, please download the latest attachment.

 

Best Regards,

Community Support Team _Charlotte

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
    4 years ago

    Hi v-zhangti ,

     

    Thank you so much for your patience and time!

     

    Finally works just fine!

     

    thanks 🙂