Forum Discussion

ashikts's avatar
ashikts
Helper II
5 years ago
Solved

date intelligence

Hello All,

Thanks for the great support from the community.As a beginner im very thankful to this .

Once again needed a help from here.

i have a data like this:

Projectemployeework datebilling ratecost ratehours
phpashik04/01/202110202
phpashik05/01/202110203
phpashik06/01/202110202
javaamit04/01/202114153
javaamit04/01/202114152
javaamit04/01/202114151
phprahul04/01/202112202
phprahul05/01/202112203

 My data is like that .We have more than 100 employees and diffrent project details.

what i want is something like that.

 

Projectemployeestart dateend datebill ratehours
phpashik04/01/202106/01/2021107
phprahul04/01/202105/01/2021125
javaamit04/01/202106/01/2021146
      
      
      

 

Please help me to resolve it

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  ashikts ,

     

    Create 2 measures as below:

    _Start date = CALCULATE(MIN('Table'[work date]),FILTER(ALL('Table'),'Table'[employee]=MAX('Table'[employee])&&'Table'[Project]=MAX('Table'[Project])))
    _End date = CALCULATE(MAX('Table'[work date]),FILTER(ALL('Table'),'Table'[employee]=MAX('Table'[employee])&&'Table'[Project]=MAX('Table'[Project])))

     And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

6 Replies

  • PC2790's avatar
    PC2790
    Community Champion
    5 years ago

    Hi ashikts ,

    You can create a new DAX table using the below formula:

    TableGrouped = 
SUMMARIZE (
    ALL(ProjectTable[Project],ProjectTable[employee],ProjectTable[work date],ProjectTable[work date],ProjectTable[billing rate],ProjectTable[hours]),
    ProjectTable[Project],ProjectTable[employee],
    "Start Date",MIN(ProjectTable[work date]),
    "End Date",MAX(ProjectTable[work date]),
    "Count", SUM(ProjectTable[hours] )
)

    The result looks like this:

    Please provide a Kudos to this answer if you found it interesting.

    If it helps to solve your query, please mark it as a solution for others to quickly find it.

    • ashikts's avatar
      ashikts
      Helper II
      5 years ago

      gettting an error "multiple table arguments are not allowed in all functon"

      • PC2790's avatar
        PC2790
        Community Champion
        5 years ago

        It works for me. Are you creating a new DAX table from Table Tools section and using the above mentioned code?

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi  ashikts ,

     

    Create 2 measures as below:

    _Start date = CALCULATE(MIN('Table'[work date]),FILTER(ALL('Table'),'Table'[employee]=MAX('Table'[employee])&&'Table'[Project]=MAX('Table'[Project])))
    _End date = CALCULATE(MAX('Table'[work date]),FILTER(ALL('Table'),'Table'[employee]=MAX('Table'[employee])&&'Table'[Project]=MAX('Table'[Project])))

     And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!