How to calculate month from custom date range

[Anonymous]

Hi All,

First off I would like to thank everyone who participates on this forum, it has really great stuff.

I'm trying to create the following report in Power BI Desktop:

here I need to calculate month from the custom date ranges.

startdate	end date	expected output
02-08-2020	05-09-2020	August
05-07-2020	01-08-2020	July
07-06-2020	04-07-2020	June

This is the date range but I need to create month column where the first row would be August, Next row would be July and so on..Basically my requirement is August should be considered from 02-08-2020 to 05-09-2020. My months startdate and enddate should be as per mentioned on the above table.

Please let me know if anyone can crack this problem.

Thanks in advance.

[ryan_mayu]

@Anonymous 

is this what you want?

Column = 
FORMAT('Table (2)'[STARTDATE],"mmmm")

[amitchandak]

@Anonymous , Not very clear. Can you share the expected output?

Refer this if you want all dates between dates

https://www.dropbox.com/s/bqbei7b8qbq5xez/leavebetweendates.pbix?dl=0

[Anonymous]

Hi,

I have mentioned the expected output as well. It's just that I need to create the month column based on mentioned startdate and enddate.

Please let me know if you have any solution for this.

[v-lili6-msft]

hi  @Anonymous 

startdate	end date	expected output
02-08-2020	05-09-2020	August
05-07-2020	01-08-2020	July
07-06-2020	04-07-2020	June

It likes a fiscal date table, and but what is the logic of your expected output.

for example:

start 02/08/2020 and end 05-09-2020, why the expected output is August not September?

and if start 28/08/2020 and end 28-09-2020, what is the expected output? August or September?

and if start 28/08/2020 and end 28-10-2020, what is the expected output? August or September or October?

Regards,

Lin