How i can see this in % ?

[Anonymous]

Hello All

It will be nice if i also receive a query for this. 

Thank you in advanced !

[Anonymous]

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]

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 !

[v-zhangti]

Hi, @Anonymous 

You can try the following methods.

Column:

% 1 = 
Var _1=CALCULATE(SUM('Table'[01 August 2021]),FILTER('Table',[Actaul Date]=MIN('Table'[Actaul Date])))
Var _2=CALCULATE(SUM('Table'[01 August 2021]),FILTER('Table',[Actaul Date]=EARLIER('Table'[Actaul Date])))
Return
DIVIDE(_2,_1)

Is this the result you were expecting?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello Thank you for your reply ,

I as saw the result but now i always have to calculate the  % 1, % 2 and so on... manually

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

like this 

[Anonymous]

In this Calculation i have Date as a Created_Date and Customer Id.