Forum Discussion
Helper IIAmounts not showing Correctly
Super UserMake sure your month and week values are unique in calendar (date) table, for example for two year (2016 and 2017), your months are like this:
Jan-2016
to
Dec-2017
not just Jan - Dec, with this your January data for both year wil be aggregated
Similar approach you to do for week, for example
Jan 1 - Jan 7, 2016 is 1st week and so on...
and then create a hierarchary (seems like you are drilling down)
Year
Month (new column as described above)
Week ( new column as described above)
and then use this hiearchary on your axis. Here is example link for calendar table
edavilathis is my date table
- parry2k
As mentioned here are teh changes or add new columns:
Month should be "Month Name - Year", in this case Jan - 2016 and so on.
Week should be "Week - Month and Year" something like "Week 1st - Jan 2016"
Two ways to do this:
- Add these column to your source table
- Create calculated column in Power BI Using DAX, let us know if you need help with this.
- edavila
PArry2k
I dont want to look more dumb that Im but, what you are saying is to add a new column to the table like
concatenate month name and year and concatenate( month name, year, week)
and I will need like and exmaple of the DAX formulas if is not too much to ask
thanks