I'm creating a lines chart in Power BI that requests a %monthly value for each month for two text variables in a column. The Y-axis is %count of tickets #, the legend is Completion Date (either 'Yes' or "No") and the X-axis is Actual date.
I need to count each month tickets and express as a % of "Yes" i.e Nov2016 count yes/Total nov2016 count for yes &no. And same for "No" . Use this values in the lines chart.
The chart is to cover 1 year stats from Nov2016 to Nov2017 and should be dynamic.
Any idea how to write this dax function.