Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am trying to create a new column in a table called, "Days since started."
I am working off of a table named "Progress". I have two columns, one named "Start Date" and another called "Completion Date."
I would like this column to calculate the following:
IF completion date is blank (no value inputed), I would like to return the value of (start date - today's date) (today's date must be dynamic for all days moving forward. ELSE there is a value in "completion date", I would like it be blank.
Below is a sample of my data with an expected result. Please note that the "26" is what I would like to return, as there is no value in "completion date" and the blanks remain for the other three rows, as there is a completion date.
@parry2k @DataZoe @AlB Hopefully one of you can help.
Best,
Cam
Solved! Go to Solution.
@chonchar try this:
New Columns =
DATEDIFF ( Table[Start Date], COALESCE ( Table[Completion Date], TODAY () ), DAY )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hello @chonchar ,
I was doing it but I was late I guess.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
Hello @chonchar ,
I was doing it but I was late I guess.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
Both work. Accordingly, both of you should have a solution credit for this post. Please verify.
Thank you both
@chonchar try this:
New Columns =
DATEDIFF ( Table[Start Date], COALESCE ( Table[Completion Date], TODAY () ), DAY )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |