Average payment for previous month

Does your date slicer include the first date of the month?  Date manipulation functions work by sliding the visible window of dates forwards or backwards depending on options.  If slicer date range is 2/3/2017 ... 2/25/2017  then DATEADD(CalendarTable[Date], -1, month)  returns 1/3/2017 ... 1/25/2017.  Then FIRSTDATE (DATEADD(CalendarTable[Date], -1, month)) will return 1/3/2017.

mattbrice You are right, my slice from 2nd day. Not first day. I thought firstdate is the 1st calendar day of each month. Actually it is the first date of slicer range. For my case, obviously I need 1st calendar day of each month and that is why EOMONTH(MIN()) works. Thanks so much for explantion. Total get it. Thanks soooooo much.

Great.  

And FYI you could also do:  STARTOFMONTH ( DATEADD ( Calendartable[Date] , -1, month ) )

and you will get the first day of the month based on the first date visible in the current filter context and then not worry about having to be as careful about slicer dates.

mattbrice, thank for information. Learned another new function.

4 average measures have been calculated so far including Last 30 days, Last 60 days, Previous month, Previous 2 months. Now I need drop down list and let user to choose which average you want to see. My idea is adding a slicer table with Average Option column which includes the above 4 average name. In the Measure table add four measures and DAX samples are below. 

Avg_Payment_Last30DaysSlicer = IF(
                                   CONTAINS(AverageSlicerTable,AverageSlicerTable[AverageOption],"Last 30 days"),
                                   MeasureFromSqlServer[Avg_PaymentAmt_Last30Days],
                                   BLANK()
                                   )

                                   )

But after I add all the slicer measures to the value and choose the option from slicer, all measures’ header are shown below include blank measures (left table). I am looking for  the way only shows the measure header and number that you chose? For example, If I choose last 60 days, only this measure shows in the table (like right table). Other blank measures including header won't show. Thanks

Set your card to use only the following measure:

Slicer_measure =
VAR _slicerSelection =
    SELECTEDVALUE ( slicer_Table[measure], "Avg_payment_Last_30days" )
RETURN
    SWITCH (
        _slicerSelection,
        "Avg_payment_Last_30days", [Avg_payment_Last_30days],
        "Avg_payment_Last_60days", [Avg_payment_Last_60days],
        "Avg_payment_PreviousMonth", [Avg_payment_PreviousMonth],
        "Avg_payment_Previous2Month", [Avg_payment_Previous2Month]
    )

But unfortunately the card will only show the category label "Slicer_Measure" and there are no formatting options to programatically change category label afaik.  But what you can do is add another card with this measure :

slicer_Measure text = SELECTEDVALUE ( slicer_Table[measure], "Avg_payment_Last_30days" )

mattbrice, Switch is enough since it only shows the measure chosen. That is exactly what I am looking for.

 For text box, it is no problem since I will put the slicer aside the measure and user will know which average measure they choose.

Thanks so much again for your quick reply.

Further requirement for this project. Need layout like below

But in power bi  those 9 numbers are from 9 different measures. The layout I got so far frow power BI is below.

All the texts are from text boxes and numbers are from multirow card without catagory lable.

But in this way, I can't adjust the distance bewteen row and columns and can't add gridline on columns or rows.  What is best way to do it? Thanks for help.