Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have a column called "Action Needed" that has alot of If conditions such as if:
[1st letter request date] = blank( ) && [Records received] = Blank ( ), "Request letters"
I am wanting to return a result of "Send 2nd request for letters" if today's date is 15 days or greater from [1st letter request date] otherwise it will be "Waiting on letters" which means it's less than 15 days from today.
I came up with but not sure: [1st letter request date] >= today () - 15 &&, "Send 2nd request for letters", "Waiting on letters"
Thank you in advance!
Solved! Go to Solution.
Hi,
If you aim to create a new column, please try something like below whether it suits your requirement.
new column CC =
IF (
[1st letter request date]
>= TODAY () - 15
&& NOT ISBLANK ( [1st letter request date] ),
"Send 2nd request for letters",
"Waiting on letters"
)
Hi,
If you aim to create a new column, please try something like below whether it suits your requirement.
new column CC =
IF (
[1st letter request date]
>= TODAY () - 15
&& NOT ISBLANK ( [1st letter request date] ),
"Send 2nd request for letters",
"Waiting on letters"
)
Thank you! I needed that NOT ISBLANK. This will help with the other actions I need to calculate.
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |