Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
I am trying to calculate running total for counts of companies.
I have created a matrix that is showing me the company names on rows and their count bucket on the columns.
Issue:
I am getting the cummulative values when there is a count for the bucket, but if it is blank then enpty bucket is shown there. (We need to show the previous value to this empty bucket).
Example:
- Company A has no value in 120 and 365 day, so both must show the value "6" which is of 90 days.
- Company Q has value only in "7 day column" that is 4, and rest are blank! So it must show "4" in all the other empty buckets (since it is the last value counted).
Here is the Sample Data
Solved! Go to Solution.
@varunt , Please find the attachment after signing
@varunt , Please find the attachment after signing
Thank You @amitchandak for the quick help. It is relly helpful.
I appreciate the efforts to the community 🙂