Forum Discussion
Values not coming for formatted Date column
Hi All,
In a year I have sales on multiple dates and i like to show in a monthly wise sales and I duplicated the date column and formatting it into month & year when I check the sales with dates all values are comming correctly but when I check with month & year colum I have formatted some of the month values are missing
Please help!
2 Replies
- danextian
Super User
Hi Anonymous ,
When you say format, did you make a calculated in DAX or a custom column in Power Query? Can you please post a sample data and the data transformation you did in Power Query?
- Idrissshatila
Hello Anonymous ,
if you want use these measures as your year and month
Year = YEAR('YourTableName'[date])Month = FORMAT(YourTableName'[date],"mmmm")If I answered your question, please mark my post as solution, Appreciate your Kudos đź‘Ť
Follow me on Linkedin
Vote for my Community Mobile App Idea đź’ˇ
