Forum Discussion

EvertonRosa's avatar
EvertonRosa
Icon for Helper I rankHelper I
5 years ago
Solved

Calculate Values based on specific dates

Community, I need a little help here.   I have a table like the one bellow and I want to define 2 measures:   1) Value of Estimated opportunities, considering first day of each month of the year....
DAX
  • EvertonRosa's avatar
    EvertonRosa
    5 years ago

    Thanks. I did find a solution.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

You will want to use  a Dates table and use its [date] column for your visuals. Once you have that you can create all your measures as needed.

  • EvertonRosa's avatar
    EvertonRosa
    Icon for Helper I rankHelper I
    5 years ago

    Thanks. I did find a solution.