Forum Discussion
Solved
Help with Line Chart
Hi, I'm trying to create a line chart to compare the number of Volume create against the numbers of volume sold to customers (Depletion in my sample file) for 2 products - Pinot Grigio and Premiu...
hi gbarr12345 ,
this link has the code with variable start and end date:
avixd/CalendarTable_with_DAX: Code samples of a calendar table using DAX (github.com)
Change what is highlighted in yellow for the output:
hi gbarr12345 ,
Attached is my solution and an image of the output. Let me know if this meets the requirements.
steps taken:
1. added a date table.
2. Create 1 to many relationships from dimensions to facts.
3. Used the date from the date table instead of the depleation/usa table.
Thank you for your response.
How did you create the date table do you mind me asking?