Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
So I have created a Measure (Billing Linearity Rolling) for calculating cumulative total over weeks.
eg= for canada week 9 value should be 39%, and Week 13 should be 100%
Any help would be highly appreciated.
Thankyou
Solved! Go to Solution.
Hi,
I got a solution to my problem. I had to change the Cross Filter Direction to "Single" from "Both" for Many to One Cardinality. And it worked.
@Anonymous , Try with +0
Billing Linearity Rolling =
CALCULATE(
[Revenue Forecast for Historical Data]+0,
FILTER(
ALLSELECTED('Period table Committed'[Week Committed]),
ISONORAFTER('Period table Committed'[Week Committed], MAX('Period table Committed'[Week Committed]), DESC)
)
)
Hi @amitchandak ,
After adding +0, Blank values are getting replaced by 0%,
This is not my requirement. I just want the blank values to show cumulative value which should be equal to previous week value. My table should look like below,
@Anonymous , 'Period table Committed' is kind of week/ date table and joined to Billing Linearity Data on date or week ?
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi @amitchandak ,
Yes Period Table is a Calendar Table which is customised. I have used 4-4-5 calendar type.
It is Joined to Billing Linearity table with Date field. And here I am using Week Committed from Period Table to get the cumulative total.
Below is the output that I am getting, and the desired output that i want,
Thanks in advance.
Hi,
I got a solution to my problem. I had to change the Cross Filter Direction to "Single" from "Both" for Many to One Cardinality. And it worked.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |