Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Return value to a specific date

Hi Power Bi Community !   I have struggled with calculating a variation betwen two specific dates, and I know it should be simple but my formula doesn't work and it drives me crazy !! My table loo...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous ,

     

    Modify your measure as below：

     

    Measure = CALCULATE(SUM('Table EBITDA'[Actual]),FILTER(ALL('Table EBITDA'),MONTH('Table EBITDA'[Time_Cal])=9&&YEAR('Table EBITDA'[Time_Cal])=2020))

     

    Or you may create a slicer table as below:

    slicer table = VALUES('Table EBITDA'[Time_Cal])

    Then create a measure as below:

    Measure 2 = CALCULATE(SUM('Table EBITDA'[Actual]),FILTER(ALL('Table EBITDA'),'Table EBITDA'[Time_Cal]=SELECTEDVALUE('slicer table'[Time_Cal])))

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

Thanks for your reply but still doesn't work, as "September 2020" isn't text but a month !

 

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Modify your measure as below：

     

    Measure = CALCULATE(SUM('Table EBITDA'[Actual]),FILTER(ALL('Table EBITDA'),MONTH('Table EBITDA'[Time_Cal])=9&&YEAR('Table EBITDA'[Time_Cal])=2020))

     

    Or you may create a slicer table as below:

    slicer table = VALUES('Table EBITDA'[Time_Cal])

    Then create a measure as below:

    Measure 2 = CALCULATE(SUM('Table EBITDA'[Actual]),FILTER(ALL('Table EBITDA'),'Table EBITDA'[Time_Cal]=SELECTEDVALUE('slicer table'[Time_Cal])))

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!