Forum Discussion
Measurement Time out
WaelTalaat79 change your measure to this:
YTD Prog. Rebates Value = VAR _Yearly_Purchases_Value = [Yearly Purchases Value] VAR _slab = [Slab-#] VAR _result = SWITCH( _slab, 0, 0, 1, SUM ( '2022 P-Rebates Slab Condition %'[Slab % 1] ), 2, SUM ( '2022 P-Rebates Slab Condition %'[Slab % 2] ), 3, SUM ( '2022 P-Rebates Slab Condition %'[Slab % 3] ), 4, SUM ( '2022 P-Rebates Slab Condition %'[Slab % 4] ), 5, SUM ( '2022 P-Rebates Slab Condition %'[Slab % 5] ), 6, SUM ( '2022 P-Rebates Slab Condition %'[Slab % 6] ) ) * _Yearly_Purchases_Value RETURN _resultMy Savior 😍
it just 5 seound "OMG , love you man"
ok that is encourge me to ask for mor 2 measure related
i need to get the monthly impacy by sbtruct the current month value - previous month
but when i do it the calcoulation consider the previous month od Jan is DEC. with value but dec. should be zeroPR for PreivMonth =(CALCULATE([YTD PR Calculate],PREVIOUSMONTH('Date'[Date].[Date])))
My Savior 😍
it just 5 seound "OMG , love you man"
ok that is encourge me to ask for mor 2 measure related
i need to get the monthly impacy by sbtruct the current month value - previous month
but when i do it the calcoulation consider the previous month od Jan is DEC. with value but dec. should be zero
WaelTalaat79 my pleasure my friend 🙂
For community visabilty better to open a new thread per question, so open a new one and I'll try to get to it. Need to leave PC for now
And hey, check out my showcase report:
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up if you liked it 🙂