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.   Th...
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

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,