Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

FillDown function based on a measure

Hey!    I am creating a dashboard that gives an overview of the current states of transaction accounts and it has to show every day (not just the current day). To create this we get information fro...
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

We can use a spreate date table as the row field to meet your requirement, please also refer to this similar thread: https://community.powerbi.com/t5/Desktop/Replacing-blank-cells-in-Matrix-visuals/td-p/612814

 

 

t = DISTINCT('CompleteList'[Posting Date])

 

 

 

CumulatieveSom = 
CALCULATE (
    SUM ( CompleteList[Remaining Amount] ),
    FILTER (
        ALL ( CompleteList[Posting Date] ),
        CompleteList[Posting Date] <= MAX ( t[Posting Date] )
    )
)

 

 


Best regards,

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-lid-msft This does not work as it messes with the cumulative function (I now see the final value of today in every cell and the cells with no transactions are still empty)

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Have you tried to use the date column in the new calculated table as the row fied instead of using the one in origin table?


    Best regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-lid-msft Yes! This changes the data in the cumulative sum measure... And it still leaves me with empty cells! We think this is because not all dates are available in the database (only the one's transactions took place on) and there is no date dimension...

       

      We created a date dimension with a measure, but this also messes with the numbers in the cumulative sum.