Forum Discussion
How to remove Date Hierarchy
Sorry wrong advise.... actually when you drag it into values, you can right click and select the date name instead of the Date Hierarchy - then it will display as a single date.
If you turn the auto date stuff off.. you would then have to have your own date tables.
Now I have one additional question Ashish_Mathur because I like to dig deeper into challenges like this. My question is WHY? Why does the weekly date need to be a column rather than a measure?
In my opinion this is duplicating an existing column from the original data. The DAX documentation for WEEKNUM() does state that it applies to a Measure. WEEKNUM()
If you have a moment, kindly help me to understand why I would need a column? What is the tradeoff of adding an additional column?
You are welcome. Measures are generally used when you want dynamic results based on slicer/filter selections. Weeknum does not have to be a dynamic solution. No matter what is selected in the slicer/filter, the weeknum of that date will remain the same.
Thank you again Ashish_Mathur for your time and attention!