locked
Filter by year RRS feed

  • Question

  • Hello. How can I return results for just a given year? 
    Tuesday, October 25, 2016 6:59 PM

Answers

  • Hi AlexMartini,

    The given year can be set up in filter. For example, using below formula calculates all the sales in 2013.

    measure:=CALCULATE(SUM(Cost[sale]),FILTER(Cost,YEAR(Cost[date])=2013))

    If it is unhelpful for your question, please share us more details and sample data, thank you very much.

    Best Regards,
    Angelia

    MSDN Community Support<br/> Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:MSDNFSF@microsoft.com">MSDNFSF@microsoft.com</a>.



    Wednesday, October 26, 2016 10:08 AM