Forum Discussion

Sudhavi_84's avatar
Sudhavi_84
Helper V
5 years ago
Solved

Dax Measure

I have a list of Projects( Comes from Table), Date (Created Measure), Total Value(Created Measure). I  am trying to make this Table in to Clustered Column Visual, but for some reason, Date Measure i...
Need Help
  • Sudhavi_84's avatar
    Sudhavi_84
    5 years ago

    Greg_Deckler , Thank you for the response.

     

    How can I achieve this one. do we have any other way to fix this?

     

    All I have is list of projects which are having different dates with different values in Current year. I need to sum all the values. I have to sum it and show with the Minimum date in the Clustered column visual.

     

    For example

     

    I have this Table

     

     

    I created this below table using mesaures

     

     

    My aim is to provide Clustred column chart

    Dates in X axis and Values in Y Axis and Projects in Column.

     

    Please any help, any other way to acheive this?

     

     

  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Sudhavi_84 Well, you could create a column like this perhaps:

    Earliest Date Column =
  MINX(FILTER('Table',[Project]=EARLIER('Table'[Project])),[Date])
  • Sudhavi_84's avatar
    Sudhavi_84
    Helper V
    5 years ago

    Greg_Deckler , Thank you for the response.

     

    How can I achieve this one. do we have any other way to fix this?

     

    All I have is list of projects which are having different dates with different values in Current year. I need to sum all the values. I have to sum it and show with the Minimum date in the Clustered column visual.

     

    For example

     

    I have this Table

     

     

    I created this below table using mesaures

     

     

    My aim is to provide Clustred column chart

    Dates in X axis and Values in Y Axis and Projects in Column.

     

    Please any help, any other way to acheive this?

     

     

    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      5 years ago

      Sudhavi_84 
      Is there a particular reason you want to use the minimum date showing the total value for each project?

      • Sudhavi_84's avatar
        Sudhavi_84
        Helper V
        5 years ago

        Not really but that was the requirement:-)

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      5 years ago

      Sudhavi_84 Well, you could create a column like this perhaps:

      Earliest Date Column =
  MINX(FILTER('Table',[Project]=EARLIER('Table'[Project])),[Date])
      • Sudhavi_84's avatar
        Sudhavi_84
        Helper V
        5 years ago

        Thanls Greg_Deckler , I will try this and will let you know.