Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register 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.