Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with time intelligence measure

Here is what I am trying to do: I am trying to create a guage where the target is: "(the amount of days per month) * (45)" with 45 being the target amount of points a sales rep want to hit per day. ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  Anonymous ,

    Here are the steps you can follow：

    1. Create calculated column.

    Day = COUNTX(FILTER(ALL('Table'),YEAR('Table'[Date])=YEAR(EARLIER('Table'[Date]))&&MONTH('Table'[Date])=MONTH(EARLIER('Table'[Date]))),[Date])
    target =
'Table'[Day] * 45

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

mh2587's avatar
mh2587
Super User
4 years ago

=COUNT([Days of Month])*45

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I do not have days of month in my calander table as shown above, what dax formula would i need to make that a new column?