Forum Discussion
bhmiller89
9 years agoHelper V
Measure for Current Month
I have a list of Opportunities and they all have create dates and close dates (projected and actual) I want to show only Opportunities created in the current month
- 9 years ago
Hi bhmiller89,
In this scenario, you don't need to populate a date table. And I have created a simple sample about how to create the calculate column which indicates if the "create Date" is within current month for your reference.
I assume you have a table called "Table1" like below.
Then you should be able to use the formula below to create the calculate column, and use the created column as Slicer to show only Opportunities created in the current month.
IsCurrentMonth = IF ( YEAR ( Table1[Create Date] ) = YEAR ( TODAY () ) && MONTH ( Table1[Create Date] ) = MONTH ( TODAY () ), "Yes", "No" )Regards
bhmiller89
9 years agoHelper V
Any suggestion on how to write this column? Do I first need to populate a date table?
dkay84_PowerBI
9 years agoMicrosoft Employee
Try this but adjust for month rather than week:
https://blog.oraylis.de/2016/02/relative-week-column-with-dax-power-query/