Bar Chart Help

Hi  Anonymous ,

 

First create a column in your fact table:

Month-day = FORMAT('Table'[date],"DD-MMM-YY")

Then create a dim table as below:

Table 2 = UNION(VALUES('Table'[Month-day]),ROW("name","WTD actual"),ROW("name","WTD Target"))

And a date table as below:

Date = CALENDAR("2021-1-1","2021-12-31")

Then create a measure as below:

Measure =
VAR _mindate =
    MINX ( ALLSELECTED ( 'Table' ), 'Table'[date] )
RETURN
    SWITCH (
        SELECTEDVALUE ( 'Table 2'[Month-day] ),
        "WTD actual",
            CALCULATE (
                SUM ( 'Table'[amount] ),
                FILTER (
                    ALLSELECTED ( 'Table' ),
                    'Table'[date] >= _mindate
                        && 'Table'[date] <= _mindate + 6
                )
            ),
        "WTD Target", 375466,
        SUM ( 'Table'[amount] )
    )

And you will see:

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!