Forum Discussion
DAX calculation
From a single Fact table I have created two measures from two different column , one is "Total Staff Attendance"=Distinctcount(Table1[Name&Date]), another measure is "NewDC"=Average(Table1[TotalDesk...
Thank you for your reply, dates on the X-axis have been dragged from the fact table( calender table have no date column , only month column is availavle)
That is not how it should be. In the Calendar Table, there should always be a Date column. All Date fields such as year, month etc. should be created in this Calendar Table and to all visuals, date related fields should be dragged from the Calendar Table.