Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Regroup measure for graph

Hi there !  After some research and some tests i can't find a solution so I decide to post here to find a solution with you guys !  I've got a dataset with several Tables but only one is about ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

     

    Thanks for your answer and your time v-yifanw-msft ! 

    I have already test with the EARLIER function but it's strange because with datas from Excel file it works easily but with my dataset from my ERP it refuses to accept the EARLIER function in my CALCULATE.

     

    I find a way to get my result.

     

    I create a new column to get an unique key by concatenating Date and ID Palette.
    Then I create a new Table with GROUPBY this Key, I had a new column to count how many rows I have for each key in the Table “Preparation”.
    And finally I regroup data of this column to create my graph.  

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

 

Thanks for your answer and your time v-yifanw-msft ! 

I have already test with the EARLIER function but it's strange because with datas from Excel file it works easily but with my dataset from my ERP it refuses to accept the EARLIER function in my CALCULATE.

 

I find a way to get my result.

 

I create a new column to get an unique key by concatenating Date and ID Palette.
Then I create a new Table with GROUPBY this Key, I had a new column to count how many rows I have for each key in the Table “Preparation”.
And finally I regroup data of this column to create my graph.  

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

I am glad to hear that you have solved the problem and are willing to share with us how you did it. Hopefully your answer will help more people!

 

Best Regards,

Ada Wang