Forum Discussion
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...
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.
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
Super User
Super UserHi,
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.