I have the data set as per the below file:
The below graph has been developed in Excel... How can I get the same result in Power BI?
My challenge is that I want to create a new table in Power BI with the following information:
1- Count of the open lots per each month from the [Lot Opened on] column in the above data set and make it count in the below new table
2- Count the closed lots per each month from the [Lot Closed on] column in the above data set and make it count in the below new table
3- Calculate the cumulative open lot and closed lot each month
4- calculate the five closed lots (Closed/open) and blot the closure percentage every month.
My challenge is that I want to create a new table in Power BI with the following information:
1- Count of the open lots per each month from the [Lot Opened on] column in the above data set and make it count in the below new table
2- Count the closed lots per each month from the [Lot Closed on] column in the above data set and make it count in the below new table
3- Calculate the cumulative open lot and closed lot each month
4- calculate the five closed lots (Closed/open) and blot the closure percentage every month.