Forum Discussion

Axiomite's avatar
Axiomite
Icon for Resolver II rankResolver II
3 years ago
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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Revise the measure to:

    Total BudgetAMT_Distinct = SUMX(GENERATE(DISTINCT(SampleData[Master_Sub_Account]),DISTINCT(dimDates[Month])),[Total BudgetAMT_Max])

    Hope this helps.

Axiomite's avatar
Axiomite
Icon for Resolver II rankResolver II
3 years ago

Ashish_Mathur, many thanks for your time in assisting, it works🙏!!

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

You are welcome.