Forum Discussion

VeemalS's avatar
VeemalS
Helper I
3 years ago

Target Allocation by Day

Hello,   I have a Target Table in EUR as follows Month Target Apr                      20,965,000 May                      18,876,560 Jun                      17,987,908 Jul   ...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi VeemalS ,

 

My Date table is as below.

Date = 
ADDCOLUMNS( CALENDAR(DATE(2022,01,01),DATE(2022,12,31)),"Year",YEAR([Date]),"Month",MONTH([Date]),"MonthName",FORMAT([Date],"MMM"))

Relationship:

Measure:

Target by Day = 
VAR _COUNT =
    COUNT ( 'Date'[Date] )
VAR _TARGET =
    CALCULATE (
        SUM ( 'Table'[Target] ),
        FILTER ( 'Table', 'Table'[Month] = MAX ( 'Date'[MonthName] ) )
    )
RETURN
    DIVIDE ( _TARGET, _COUNT )

Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

VeemalS's avatar
VeemalS
Helper I
3 years ago

Thanks. The allocated amount by day is ok. However, from this how do I calculate an MTD amount?

 

Brgds

 

Veemal