Forum Discussion
About creating a complex report
Hi Anonymous
You could create a column first
date column = RIGHT('Table (2)'[Column1],2)&"/"&"01"&"/"&LEFT('Table (2)'[Column1],4)Then use this date column in my formula.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi, v-juanli-msft
think very much
Now I have a problem again. I want to create a new measurement value of ATA_MONTH. This field is in my excel data, but BI tells me that I do not have it when I create the measurement value
Then I want the data of ata_month to be turned into English instead of Numbers in the report. Do you know how to solve these two problems
Best Regards
alan-li
Hi Anonymous
You could create a measure
Measure = FORMAT(MAX('Table'[date]),"yyyy-mmmm")
Or a column
Column = FORMAT('Table'[date],"yyyy-mmmm")
See reference for "FORMAT"
https://docs.microsoft.com/en-us/dax/format-function-dax
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi, v-juanli-msft
The month worked, but my year changed to look like the one in the picture
My field is of type number,
if I change the field type to date in edit view
My BI Desktop is in the us,This problem is driving me crazy,Can you imagine why my year is like this
Best Regards
alan-li
Hi Anonymous
You could create a column first
date column = RIGHT('Table (2)'[Column1],2)&"/"&"01"&"/"&LEFT('Table (2)'[Column1],4)Then use this date column in my formula.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.