https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/One-Value-for-all-days-of-month/m-p/1543511#M30447 <LI-CODE lang="csharp">[Monthly Goal Extended] = // YearMonthID must be something that uniquely // identifies the month across the entire Calendar. // It could, for instance, be the integer YYYYMM. var __months = DISTINCT( 'Calendar'[YearMonthID] ) var __sumOfMonthlyTargets = calculate( sum( 'Monthly Targets'[Projected Amount] ), __months, removefilters( 'Calendar' ) ) return __sumOfMonthlyTargets</LI-CODE> Thu, 10 Dec 2020 16:32:25 GMT daxer-almighty 2020-12-10T16:32:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/One-Value-for-all-days-of-month/m-p/1543396#M30435 <P><SPAN>I have two tables connected to a calendar table. One has daily values ​​from the beginning and until the end of the month. Another table has a monthly target value, that is, that table only has one day per month. How do I return this value for every day on a chart? watch</SPAN></P><P>&nbsp;</P><P><SPAN>In the goal table, there is only the 20th of each month, but I wanted to expand this value as if it were a monthly goal, you know?</SPAN></P><P>&nbsp;</P><P><SPAN><img /></SPAN></P><P>&nbsp;</P><P><SPAN><img /></SPAN></P> Thu, 10 Dec 2020 15:20:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/One-Value-for-all-days-of-month/m-p/1543396#M30435 Anonymous 2020-12-10T15:20:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/One-Value-for-all-days-of-month/m-p/1543511#M30447 <LI-CODE lang="csharp">[Monthly Goal Extended] = // YearMonthID must be something that uniquely // identifies the month across the entire Calendar. // It could, for instance, be the integer YYYYMM. var __months = DISTINCT( 'Calendar'[YearMonthID] ) var __sumOfMonthlyTargets = calculate( sum( 'Monthly Targets'[Projected Amount] ), __months, removefilters( 'Calendar' ) ) return __sumOfMonthlyTargets</LI-CODE> Thu, 10 Dec 2020 16:32:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/One-Value-for-all-days-of-month/m-p/1543511#M30447 daxer-almighty 2020-12-10T16:32:25Z