Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to recreate the following calculation into a DAX Measure. Please can someone advice how ths is possible:-
if {Job_Mth}<={Current Month (Year Month YYYY-MMM Selection from Slicer} then
SUM{Job Projected Pounds}
else
SUM{Job Contract Amount}
Thanks in advance
Hi @Anonymous ,
You could try to use DATEVALUE function converts a date in "YYYY-MMM" format to a date in datetime format. Your formula can be recreated into a measure.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous it is not at all clear what your data model looks like so it is not possible to give an answer. Please share a picture of the model and the fields.