Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dax - New Measure to count values within current Month

Hi All,   Need some help please.  I need to present a table based on data for the current month?!   I have a simple dataset, list of dates throughout the year, but i need to create a table counti...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Easiest thing to do would be to create a calculated column like:

     

    IsCurrentMonth = 
VAR __today = TODAY()
VAR __date = [Date of Joining]
RETURN
IF(YEAR(__today) = YEAR(__date) && MONTH(__today) = MONTH(__date),1,0)
charancvg's avatar
charancvg
Frequent Visitor
7 years ago

The other option is to create another column which only tracks whether the date of joining column shows "current month"

for example: 

Current Month = if(MONTH([Date of Joining])= MONTH(TODAY()),"Current","Other")

 
Once the current month column is accessible you can build different visualizations with Branch Code column.
 
*Condition: The date of joining column should be Date/time data type.