Created date - Today's Date

[KimC2504]

Hi There,
I am using PowerBI and I have been asked to show all opportunities that have been created in the last 50 days. How would you approach this? I was thinking of a custom column with a formula?

Note, dates below are in DD/MM/YYYY format.

Oppty #	Oppty Name	Created Date	Amount
OPE-123	Example 1	1/1/2020	1000
OPE-234	Example 2	5/12/2019	500
OPE-125	Example 3	1/4/2020	750
OPE-111	Example 4	10/4/2020	999
OPE-222	Example 5	20/2/2020	800

 

[sandy666]

maybe: [Created Date] >= Date.AddDays(DateTime.LocalNow(),-50) then filter by TRUE

 

[KimC2504]

Hi @sandy666,

Thanks for your suggestion, unfortunately that doesn't work as you cannot apply operator > to Date Time and Date

I was also trying to create a custom column with Created Date after 1/2/2020 but I had no luck with that either.

[Created Date]<DATE(2020,2,1)

 

[sandy666]

try Date.From([Created Date]) >= Date.AddDays(Date.From(DateTime.LocalNow()),-50)
of course it should be in custom column

 

[KimC2504]

Hi @sandy666, thank you so much, that worked perfectly.

I am also trying to create a custom column that was created after 1/2/2020 instead of -50 days.

I have tried

Date.From([Created Date]) >= Date.AddDays(Date.From(2020,2,1)))

but get error message(3 arguments were passed to a function which expects between 1 & 2)

Am I close? I am struggling with these dates formula's and I am trying to find some good tutorials to learn them.

 

[sandy666]

thank you so much, that worked perfectly.

You are welcome

I am also trying to create a custom column that was created after 1/2/2020 instead of -50 days.

this is a different question
could you explain what are you trying to do ?
anyway try: Date.From([Created Date]) >= #date(2020,2,1)

 

[KimC2504]

@sandy666 My manager has asked me a different question! They are always changing their minds!
I tried out your new suggestion and it is amazing. Thanks again

 

[sandy666]

They are always changing their minds!

I know, this is a pain in ass

Thanks again

You are welcome
Thanks for the feedback