Forum Discussion
Creating a Cumulative Line Chart
I am working on a report which calculates the percetage of cars sold per month , with the null value being the ones not sold. I have managed to create the below dataset and calculated the percetages ...
Hi Arranafc19,
Is your month column in number or text?
Are you using a date column?
What was the measure you used for cumulative?
And lastly can you share a mockup of your file?
If it's sensitive information please share trough private message.
Regards
MFelix
Is your month column in number or text?
Are you using a date column?
What was the measure you used for cumulative?
And lastly can you share a mockup of your file?
If it's sensitive information please share trough private message.
Regards
MFelix
Hi MFelix
I basically have the below columns in my query:
name,
start date,
end date,
month of close (Datediff between end and start if there is one).
Then in power bi , i am grouping this to get a count of the number closures per the month of closure and using a slicer to filter this by the start date. If there is no end date , this is grouping as a null date of closure. I am then calculating the percentage breakdown using the above mentioned measure.
What I need to do is calucalte the the cumulative percentage , but only starting from month one , not using the null value percentage