Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sum by date with condition

Hi I am new to power BI and would like to seek for the following advice.   Data: Item Sales Date Apple 10 01/01/2022 Orange 20 01/01/2022 Lemon 15 01/01/2022 Apple 30 01/0...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Thank you for your feedback.

    If you only need to have a Month Slicer, I suggest creating a Month Column when creating a Calendar table. I added a Month column into a calendar table in the attached file.

    Please check the below picture and the attached file whether it suits your requirement.

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

 

 

Expected measure: = 
CALCULATE (
    SUM ( Data[Sales] ),
    DATESINPERIOD ( 'Calendar'[Date], LASTDATE ( 'Calendar'[Date] ), 3, MONTH )
)

 

Only apple expected measure: = 
CALCULATE ( [Expected measure:], 'Item'[Item] = "Apple" )

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Kim,

 

May you include a month filter as exmaple? I can only show 1 result when a date picked instead of a completed list.

 

Thank you.

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    Thank you for your feedback.

    If you only need to have a Month Slicer, I suggest creating a Month Column when creating a Calendar table. I added a Month column into a calendar table in the attached file.

    Please check the below picture and the attached file whether it suits your requirement.