Dax help required

Anonymous · ‎05-02-2020

Hi can you help me to carry forward remaining from last quarter to current quarter, also for percentage of q2= excel formula Q2achieved/(q2Target+remaining of Q1)

Quota	30,000.00	50,000.00	70,000.00	50,000.00
win	256,947.58	50,273.30	-	-
Win Percentage	856.49%	-28.41%	0.00%	0.00%
Remaining Target	(226,947.58)	(227,220.88)	70,000.00	50,000.00

Greg_Deckler · ‎05-02-2020

Not sure what I am looking at, source data, current output, expected output? I don't see any column names. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...