Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello All,
I have a dax function which gives cumulative running sum for claims in my report. So here iam getting the expected values, However i have some blank rows in between so they should fill with the Non-blank value. Below is the dax function please help me if you aware of this. For ex : index 28 29 31 32 should fill with above non blank value 321. in the same way other blank rows should fill with their top non blank value
Claims running total in index =
CALCULATE(
SUM('Table'[Claims]),
FILTER(
ALLSELECTED('Table'[index]),
ISONORAFTER('table'[index], MAX('table'[index]), DESC)
)
So please modify the above dax function to show non blank values repeated where there are blank rows
Thank you
)
Hello All,
Can anyone help on the above question, Thanks
Hello @mlsx4
Thank you for your help.
The above dax function did not worked for me.
So here i have a matrix table where iam showing index and claims in rows and date in columns. Here iam trying to achieve cumulative running sum for the claims. However iam getting correct values but also getting some blank values. So as per below table the above non blank value should repat where ever there is a blank below>
here iam using
Index Column
claims cloumn
Date column
Index | claimsvalue for 9/19/2023 | claimsvalue for 9/18/2023 |
1 | 46 | 22 |
2 | 88 | 22 |
3 | 88 | 22 |
4 | 88 | 34 |
5 | 99 | 34 |
6 | 99 | 34 |
7 | 99 | 34 |
8 | 100 | 80 |
Hi @Prasad54
It's difficult to know if it works without data, but try:
Claims running total in index =
CALCULATE( LASTNOBLANKVALUE(Table[index],SUM('Table'[Claims])),
'Table'[index]<= MAX('table'[index]),
REMOVEFILTERS()
)
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
94 | |
88 | |
35 | |
32 |
User | Count |
---|---|
153 | |
101 | |
82 | |
63 | |
52 |