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

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