Forum Discussion

bdeluca's avatar
bdeluca
Frequent Visitor
5 years ago
Solved

Add a value to current month

Hello. Simple concept, but I'm not sure how to do it.

 

I have monthly data in a bar chart. If it is after the 15th of the month, I want to add 100 to the measure for the current month only.

 

This is an unsuccessful attempt (because it adds 100 to every month):

 

CALCULATE( IF( day(today()) < 15 , 0 , CALCULATE([measure] + 100 , FILTER('Calendar' , 'Calendar'[CurMonthOffset] = 0 ) ) ) )
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, bdeluca 

    Thank you for your feedback.

    Please check the below picture.

    Because today is 13th May, and in order to check whether the measure works or not, I input day=12 and it seems working properly. 

    Inside the sample pbix file, I input day = 15.

     

     

    https://www.dropbox.com/s/ztmyqf0zkt7gks6/bdeluca.pbix?dl=0 

     

    Values Total Custom condition =
    SWITCH (
    TRUE (),
    DAY ( TODAY () ) < 15, [Values Total],
    DAY ( TODAY () ) >= 15,
    IF (
    MAX ( Data[Dates] ) = EOMONTH ( TODAY (), 0 ),
    [Values Total] + 100,
    [Values Total]
    )
    )
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

4 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, bdeluca 

    Please check the below picture and the sample pbix file's link down below.

     

     

    Values Total Custom condition =
    IF (
    MIN ( dates[Date] ) > EOMONTH ( TODAY (), -1 )
    && MAX ( dates[Date] )
    < EOMONTH ( TODAY (), -1 ) + 15,
    [Values Total],
    IF (
    MIN ( dates[Date] )
    >= EOMONTH ( TODAY (), -1 ) + 15
    && MAX ( dates[Date] ) <= EOMONTH ( TODAY (), -0 ),
    [Values Total] + 100,
    [Values Total]
    )
    )
     
     
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

    • bdeluca's avatar
      bdeluca
      Frequent Visitor
      5 years ago

      So close!

       

      My data is grouped by month. So I only want to add 100 to the total for the month (not 100 to each day).

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

        Hi, bdeluca 

        Thank you for your feedback.

        Please check the below picture.

        Because today is 13th May, and in order to check whether the measure works or not, I input day=12 and it seems working properly. 

        Inside the sample pbix file, I input day = 15.

         

         

        https://www.dropbox.com/s/ztmyqf0zkt7gks6/bdeluca.pbix?dl=0 

         

        Values Total Custom condition =
        SWITCH (
        TRUE (),
        DAY ( TODAY () ) < 15, [Values Total],
        DAY ( TODAY () ) >= 15,
        IF (
        MAX ( Data[Dates] ) = EOMONTH ( TODAY (), 0 ),
        [Values Total] + 100,
        [Values Total]
        )
        )
         

        Hi, My name is Jihwan Kim.


        If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


        Linkedin: linkedin.com/in/jihwankim1975/

        Twitter: twitter.com/Jihwan_JHKIM

  • HashamNiaz's avatar
    HashamNiaz
    Solution Sage
    5 years ago

    Hi !

    You can use following DAX to get the desired output;

     

    New Measure = 
    VAR _CurrentYear = YEAR(TODAY())
    VAR _CurrentMonth = MONTH(TODAY())
    VAR _CurrentDay = DAY(TODAY())
    VAR _SelectYear = MAX('Calendar'[Date].[Year])
    VAR _SelectMonth = MAX('Calendar'[Date].[MonthNo])
    VAR _SelectDay = MAX('Calendar'[Date].[Day])
    VAR _AddToMeasure = IF(_SelectYear = _CurrentYear && _SelectMonth = _CurrentMonth && _CurrentDay >= 15, 100, 0)
RETURN
    CALCULATE([Measure] + _AddToMeasure)

     

    You are checking Current Year & Month from Today(), then you are validating if against Selected Year &  Month if both are same & day is greater then equal to 15 than assign 10 else 0

    You can then use this expression to add to your existing measure.

     

    Regards,