Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
I have below expression , now return Mar 2021 , i like to know by tomorrow will is return Apr 2021 ? instead of waiting for tomorrow. it there a way to test ?
Solved! Go to Solution.
Hi @admin11 ,
Create a measure as below:
Measure = FORMAT(TODAY()+1,"mmm-yyyy")
And you will see:
Assume that today is Apr 30:
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @admin11 ,
Create a measure as below:
Measure = FORMAT(TODAY()+1,"mmm-yyyy")
And you will see:
Assume that today is Apr 30:
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
@admin11 , Try like
Month Previous =
FORMAT(eomonth(TODAY(),-1),"mmm-yyyy")