Date Table used for YTD, MTD, QTD, Prior YTD etc

[dkresge]

Hello, I am new to Power BI so I am trying to learn as much as i can about how it sould be set up and how to create the measures as efficiently and easily as possible.  We have a day table and a manufacturing hours table.  We are trying to create the YTD, MTD, Prior YTD measures.  I understand how to create them using the expression below.   However, I would like to not specify "what to calculate", is there a way to make it dynamic?  I want to pick YTD at a very high level and then add the specific table column data to the matrix/table.  Please forgive me if this is hard to understand.

EarnedHrs MTD =

TOTALMTD(SUM('DirectLabor'[EarnedHrs]), 'Day'[CalendarDate])

I would like to be able to choose the month and then the time perspecive like the screen shots below.  Is there a way to accomplish this?

Thanks in advance for all your help and input!

Denise

[v-juanli-msft]

Hi @dkresge 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @dkresge 

You can refer to this article.

1. Create a column to transform the format of Date and create a slicer:

Month Year = FORMAT([Date],"mmmm yyyy")

2. Create a ‘Measure Selection’ table and create a slicer, this table has no relationship with other tables

      3.Create ‘Measure Selection’ measure:

Selected Measure =
VAR MySelection =
    SELECTEDVALUE ( 'Measure Selection'[Measure Name], "MTD" )
RETURN
    SWITCH (
        TRUE (),
        MySelection = "MTD", [Measure MTD],
        MySelection = "QTD", [Measure QTD],
        MySelection = "YTD", [Measure YTD],
        MySelection = "Prior YTD", [Measure Prior YTD],
        [Measure MTD]
    )

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.