Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How i can see this in % ?

Hello All It will be nice if i also receive a query for this.      Thank you in advanced !  
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

hi

 

create a new table with the following dax code

 

 

Table 2 =
SELECTCOLUMNS (
'Table',
"Date", 'Table'[Date],
"01 August 2021",
DIVIDE (
'Table'[01 August 2021],
MAX ( 'Table'[01 August 2021] )
),
"01 September 2021",
DIVIDE (
'Table'[01 September 2021],
MAX ( 'Table'[01 September 2021] )
),
"01 October 2021",
DIVIDE (
'Table'[01 October 2021],
MAX ( 'Table'[01 October 2021] )
)
)

 

 

If this post helps, Accept this as a solution

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello Anonymous 

     

    I will not have that values automatically. I want those all valuses automatic in different table.

     

    like this 

     

     

     

    Right now i have Date as Created_Date and also Player_Id. Based on that i need that Count which is there in first tabel 136 and so on...

    And percentaion based on that count and both should have in different table. 

     

    Thank you !