DAX 和 FORMAT 函数 [英] DAX and FORMAT function

问题描述

我有一个包含日期、月份和年份的日期字段.在我的可视化中，我需要以(MON-Year)格式显示日期.我切换到数据视图，使用

i have a field for date with date, month and year.In my visualization, I need date to be displayed in (MON-Year) format. I switched to data view, created calculated column with

Mon-Year = FORMAT('table'[Date],"YYYY-MM")

现在它显示为(年份和月份编号)，但我想将其更改为月份名称.数据视图更改后，当我关闭应用时，该列存在，但没有可见的数据类型.

Now it's getting displayed as (YEAR and Month number) but I want to change it as month name. After changes in data view, when I close apply, the column is present but there is no data type visible.

我应该分别为年和月创建不同的计算字段，然后将它们连接起来吗?任何帮助将不胜感激.

Should I create different calculated fields for year and month separately and then concatenate it? any help would be appreciated.

推荐答案

如果你想先一个月，那么也许你应该这样指定.

If you want month first, then maybe you should specify it that way.

Mon-Year = FORMAT('table'[Date],"MMM-YYYY")

这可能对你有用:

https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function

这篇关于DAX 和 FORMAT 函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！