Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Hi @GunnerJ ,
Create your measure like so:
Post Date Message = VAR startdate = CALCULATE ( MIN ( GL_TRAN_ACT[GL_POST_DT] ), ALLSELECTED ( GL_TRAN_ACT[GL_POST_DT] ) ) RETURN IF ( startdate < DATE ( YEAR ( TODAY () ), 1, 1 ), "Equity % of Asset Visual only calculates on or after the start of the current year", "" )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @GunnerJ ,
Create your measure like so:
Post Date Message = VAR startdate = CALCULATE ( MIN ( GL_TRAN_ACT[GL_POST_DT] ), ALLSELECTED ( GL_TRAN_ACT[GL_POST_DT] ) ) RETURN IF ( startdate < DATE ( YEAR ( TODAY () ), 1, 1 ), "Equity % of Asset Visual only calculates on or after the start of the current year", "" )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think you to get min date of slicer first and then use it compare with '2019-01-01'
var _start_date_1 = minx(GL_TRAN_ACT,SELECTEDVALUE(GL_TRAN_ACT[GL_POST_DT]))
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |