Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Make a groupby on distinct value

Hello, Is it possible to make a summarize table I want just to make a distinct select on my fact table for example: Week Shop Sales Buy 2008-05 Shop2 10€ -5€ 2008-05 Shop4 15€ -25...
Need Help
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
3 years ago

Anonymous You can also utilize SUMMERIZE DAX to achieve the expected output. Create a new table using below DAX:

Table 2 = SUMMARIZE('Table','Table'[Week],'Table'[Shop],"Sales",MAX('Table'[Sales]),"Buy",MAX('Table'[Buy]))
 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    The problem is my week column is from my date table so when I make the same formule it's done that :

    The result is good for the IN but it is false for the OUT because we muste have minus 4 OUT in total in "OUT" column in the third line for the week five of 2008. 

    Here is the table that summarizes the number of entries and exits per week :

     

    For the futher information in my Fact Data table I have a two important Date the date for the IN and the date for the OUT, and my Date table are link on the two date :