Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I'm using a model -- connect power bi dataset with DirectQuery mode. When I use the following smart narrative statement "maximum date MMM" in this model, it returns "APR". I did not apply any filters. The Desktop version that I'm using is 2.116.884.0 64-bit (April 2023).
The data I used in the original dataset are as follows.
| Date_YYYY | Date_MMM |
| 2021 | APR |
| 2021 | AUG |
| 2021 | DEC |
| 2021 | FEB |
| 2021 | JAN |
| 2021 | JUL |
| 2021 | JUN |
| 2021 | MAR |
| 2021 | MAY |
| 2021 | NOV |
| 2021 | OCT |
| 2021 | SEP |
| 2022 | APR |
| 2022 | FEB |
| 2022 | JAN |
| 2022 | MAR |
| 2022 | MAY |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.