Forum Discussion
Help with a Dax Formula
Is the table your raw data format or the table visual?
If it's your raw data,
1. select the first column and unpivot other columns in PQ
2. create a new column
3. change the type to date
4. use DAX to create a column
Column =var _last=maxx(FILTER('Table','Table'[Month]=EARLIER('Table'[Month])&&'Table'[Custom]=EDATE(EARLIER('Table'[Custom]),-1)),'Table'[Value])return if (ISBLANK(_last),BLANK(),'Table'[Value]-_last)pls see the attachment below
Hi hstgeorge
Just wanted to follow up to see if the DAX steps shared by ryan_mayu hnguy71 Ashish_Mathur helped in resolving your issue with calculating the month-over-month variance. We hope the guidance provided brought you closer to your solution.
If you’re still encountering difficulties or if there’s anything unclear in the approach, please feel free to reach out. We’re more than happy to walk through the logic or help you tailor the formula to your specific data model.
Also, if you’ve found an alternative solution or any insights that might help others facing similar challenges, we’d love for you to share your experience with the community!
Looking forward to hearing from you.
Thanks again for being an active part of the Fabric Community!
Hi hstgeorge ,
Just checking in to see if the DAX guidance shared by hnguy71 ryan_mayu helped resolve your issue with calculating month-over-month variance.
If you’re still running into challenges or need help adapting the formula to your model, feel free to reach out we’d be glad to assist further.
And if you’ve discovered a different solution or approach, we’d love for you to share it with the community to help others with similar questions.
Looking forward to your update!!
If we don’t hear back, we may close this thread in line with our community guidelines, but you’re always welcome to post a new query anytime.
Thank you for being part of the Microsoft Fabric Community!