Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I am using the below formula and i get the following result = 4-2019
i want the result to be a shortened version of year, so result wanted = 4-19
how do i achieve this?
Solved! Go to Solution.
@Sean-OReilly , supposing the PURCHASEORDERS_ORDERS[DELIVERY_DATE] column is date format, you might want to try,
M-YY = FORMAT( PURCHASEORDERS_ORDERS[DELIVERY_DATE], "M-YY" )
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
@Sean-OReilly , supposing the PURCHASEORDERS_ORDERS[DELIVERY_DATE] column is date format, you might want to try,
M-YY = FORMAT( PURCHASEORDERS_ORDERS[DELIVERY_DATE], "M-YY" )
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |