Forum Discussion

AKath_12's avatar
AKath_12
Frequent Visitor
1 year ago

Help! How do I roll forward the latest value

Hi,    I have a set of data carrying a value each year, by different locations; the value could be different, too.  Since the value only comes in once per year on a specific month, however, I need...
AKath_12's avatar
AKath_12
Frequent Visitor
1 year ago

Hi,

 

Thanks for the suggestion. This is the relationship auto-corrected by the PBI. 

 

I got a better result displayed, however, still not what I am looking for, for example, 1.99 should carry forward to 202307 till 202403 and 1.22 from 202404 till 202412, however, this is not happening with this DAX formula. It displayed with the Max value 2.33 instead. Any idea how this can be adjusted? Thanks for your help. 

 

 

 

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

The relationship looks correct now.

What is the purpose of 'Result table'[Location] > _byLocation? Should it not be = ?

  • AKath_12's avatar
    AKath_12
    Frequent Visitor
    1 year ago

    = give me a result display in individual months only,

     

    > Give me result display every month, 

     

    any other DAX formula can help me fix my problem? 😖