I have a table like below and created the Measures like MTD_Current_Volume and MTD_Previous_Volume .Now i need individual Average of current and previous month of volume in diffrent columns like avg Current month and avg previous month.
Let's take the below scenario as an example. There are only two records in October. The AVERAGE function will return (100 + 210) / 2 = 155 while (100 + 210) / 31 = 10. Which one do you prefer? Can you hardcode the 31? If you have the answers to these two questions, the solution could be clear.
Best Regards, Dale
Community Support Team _ Dale If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.