Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to get the cumulative total of Stock Days as per the FirstOutExpiryRank sequence.
But, as you can see Cumm Total is showing 53.24 instead of 32.96703. Please help me to fix it.
You can download sample pbix file. Thank you
Solved! Go to Solution.
@Anonymous
You modified formula as follows:
Cumm Total =
var __id = MAX(SummarizedCurrentHOStock[Product Code])
var _rank = MAX(SummarizedCurrentHOStock[FirstOutExpiryRank])
return
IF( HASONEVALUE(SummarizedCurrentHOStock[Product Code]),
SUMX(
FILTER(
ALLSELECTED(SummarizedCurrentHOStock),
SummarizedCurrentHOStock[Product Code] = __id &&
SummarizedCurrentHOStock[FirstOutExpiryRank] <= _rank
),
[Stock Days]
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
You modified formula as follows:
Cumm Total =
var __id = MAX(SummarizedCurrentHOStock[Product Code])
var _rank = MAX(SummarizedCurrentHOStock[FirstOutExpiryRank])
return
IF( HASONEVALUE(SummarizedCurrentHOStock[Product Code]),
SUMX(
FILTER(
ALLSELECTED(SummarizedCurrentHOStock),
SummarizedCurrentHOStock[Product Code] = __id &&
SummarizedCurrentHOStock[FirstOutExpiryRank] <= _rank
),
[Stock Days]
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
96 | |
89 | |
73 | |
61 | |
58 |