Forum Discussion

kdrees21's avatar
kdrees21
Icon for Helper I rankHelper I
5 years ago

Help with Measure to pull a point in time based on Matrix

I have a matrix where I have 2 different dates. One set of date is in my rows and the other is in the columns.

 

I am trying to write a formula that pulls the first number in each row. 

 

Example: I want to use the first value in each row as a divisor for each month after.

So 1/1/2019 would be 10/10, 2/1/2019 would be 8/10, 3/1/2019 would bw 6/10.... etc

then for 2/1/2019 in my rows I would start with 2/1/2019 = 20/20, then 3/1/2019 would be 18/20 and so forth

 

Any suggestions on how I could write a DAX expression to always pull these values as my divisor? 

 

Any help is appreciated.

 

 1/1/20192/1/20193/1/20194/1/20195/1/20196/1/2019
1/1/20191086200
2/1/2019 201815139
3/1/2019  30252421
4/1/2019   403933
5/1/2019    5044
6/1/2019     60

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    kdrees21 

    DAX is written based on the source table not one specific visual. Please provide a sample pbix including the 2 dates and the value in the matrix.

     

    Paul Zheng _ Community Support Team