Forum Discussion
Solved
Fiscal YTD when using MAX
Good day, Current with a table containing various columns but primarly a TxDate,Description, Acutal Amount, Accounts, Budget_Amount. The Actual Amount is on the Description level while the Budget a...
Hi,
Revise the measure to:
Total BudgetAMT_Distinct = SUMX(GENERATE(DISTINCT(SampleData[Master_Sub_Account]),DISTINCT(dimDates[Month])),[Total BudgetAMT_Max])Hope this helps.
Ashish_Mathur, many thanks for your time in assisting, it works🙏!!
You are welcome.