Create Date List

[billuran2009]

HI I am creating a custom column that will expand the rows based on the Denied from (Start) and Thru(Stop).

{Number.From([DeniedFrom])..Number.From([DeniedThru]-#duration(1,0,0,0))}

I use the above formula. However if the Denied From and Thru Date are the same I get a null value  when I expand the rows. I want it to equal the Denied From Value.

[v-angzheng-msft · Accepted solution]

Hi, @billuran2009 

You can add an IF condition,like:

if List.Count({Number.From([DeniedFrom])..Number.From([DeniedThru]-#duration(1,0,0,0))})=0 
then {[DeniedFrom]} 
else {Number.From([DeniedFrom])..Number.From([DeniedThru]-#duration(1,0,0,0))})

Result:

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@billuran2009 , are these dates, then you need List.dates

refer if needed

https://www.youtube.com/watch?v=so_A22HXbwM

[billuran2009]

Yes they are dates. What would the formula be?