Forum Discussion
keckraguilar
2 years agoFrequent Visitor
Dynamic YTD Formula (DAX)
I have two tables, budget and sales. I want to create a dynamic ytd budget formula that only sums the data through the max month in the sales table. I already converted the month name to numbers. ...
- 2 years ago
Hi,
PBI file attached.
Hope this helps.
keckraguilar
2 years agoFrequent Visitor
Here you go. The google doc has additional fields. and yes FY months are July-June
https://docs.google.com/spreadsheets/d/1ACn_70cU0GS1_FO-FAt8LFdDLfbz4TsWfYyYOAWpUJM/edit?usp=sharing
Ashish_Mathur
2 years agoSuper User
Hi,
PBI file attached.
Hope this helps.