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 @Anonymous
In your formula,"01/04" is text format,but selectedvalue('Date'[Year]) is number format.They are different types.
DATEVALUE( "01/04"&"/"&selectedvalue('Date'[Year]) )
You may change the above to below formula.They should be in same number format.
DATE( selectedvalue('Date'[Year]);4;1 )
Regards,
Hi @Anonymous
In your formula,"01/04" is text format,but selectedvalue('Date'[Year]) is number format.They are different types.
DATEVALUE( "01/04"&"/"&selectedvalue('Date'[Year]) )
You may change the above to below formula.They should be in same number format.
DATE( selectedvalue('Date'[Year]);4;1 )
Regards,
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |