cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gabrielm97
Helper I
Helper I

One Value for all days of month

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

 

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?

 

Screenshot_3.png

 

Screenshot_2.png

1 ACCEPTED SOLUTION
daxer-almighty
Solution Sage
Solution Sage

[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

View solution in original post

1 REPLY 1
daxer-almighty
Solution Sage
Solution Sage

[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

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.