Forum Discussion
Creating a Cumulative Line Chart
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
Hi Arranafc19 ,
Is it possible to share a sample file, if the information is sensitive create a mockup data or send it trough private message.
One other question is about month of close (Datediff between end and start if there is one), what do you mean this is the datediff are you getting a month number or a difference in months?
Regards,
MFelix
Hi MFelix
I created a basic mock version of how my pbix looks .
For the month of closure , I am using a datediff function in sql to get the difference in months between start and end date with null being returned if no end date.
You will see in my table I have the calculated percentage breakdown , I just need to make this cumulative , not including values that have a null month of closure
https://drive.google.com/drive/folders/1VyPBz5Vx5W3NuOsyvGcQgfnPhbUhDAOf