October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Hi good day can anyone assist me on my query. I have table, I want the Stutus
"Not Startted" if the date is in coming or in futere
"Delayed" if the date already pass on the end date and the progress is lessthan 100%
"In-progress" if the progress is lessthan 100% and the current date not exceed on the end date
"Completed" if already 100% in Remark column
OUTPUT
Thank you
Solved! Go to Solution.
Hi @AllanBerces
You can create a calculated column with the dax :
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @AllanBerces
Try this Code
Hi @AllanBerces
You can create a calculated column with the dax :
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Happy to help 🙂
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |