Forum Discussion
Dynamically find the previous 3 months average
Hi All, I'm newbie to this forum and here is my first post. I am trying to create a column that shows the prev 3 months avg. forecasted dynamically. Evey new months added to the table automatical...
Could someone help me to find a solution or idea using DAX expression. By the way, I'm new in PBI and DAX. Thanks.
Below is a sample data
dt total IN Total OUT Good OUT% Good% 3MonthsFcst 2/1/2019 79606 51384 0 0.65 0.00 3/1/2019 84194 61211 0 0.73 0.00 4/1/2019 92458 67807 0 0.73 0.00 5/1/2019 94531 66988 95 0.71 0.10 70.93% 6/1/2019 29832 18181 2903 0.61 9.73 67.98%
Hi Anonymous - I just noticed this hadn't had much traction and took a look and it seems like a DAX problem rather than something that needs developer focus. You might get a faster response in the DAX Forum of the community, as a lot more people frequent that one and are more readily available to assist you.
Regards,
Daniel
Thank you for giving me the right direction to post my concerned.
