Forum Discussion

NLEIGH's avatar
NLEIGH
Helper I
1 year ago

Current month values with DAX

Hi,   I have created a new measure which shows values for the whole year, however I also want to have a measure where I can only see values for current month.  The current measure I have is called ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi NLEIGH ,

 

Maybe you can try formula like below:

Overall Gain = SUM('Table'[SalesAmount])
Current Month Gain = 
CALCULATE(
    [Overall Gain],
    FILTER(
        ALL('Date'),
        'Date'[Year] = YEAR(TODAY()) &&
        'Date'[Month] = MONTH(TODAY())
    )
)
Whole Year =
CALCULATE (
    SUM ( 'Table'[SalesAmount] ),
    YEAR ( 'Date'[Date] ) = YEAR ( TODAY () )
)

 

 


Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

NLEIGH's avatar
NLEIGH
Helper I
1 year ago

Hi Adam,

 

Many thanks for taking the time to reply and give a detailed answer.  However I think I now have a solution from another member.  I appreciate your time & effort.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi NLEIGH ,

     

    If the issue has been resolved, would it be possible to mark it as resolved and I look forward to your feedback.

     

    Best regards,

    Adamk Kong