Forum Discussion
Multi year Line chart. the problem is that the dates data are in one Column!
Hello Everyone, Newbie to PBI here, I'm trying to create a line chart that shows sales and 2 lines of 2 different years. In fact, it's a sale comparison between 2 years (2010/2011) for the same p...
Drag date to both Axis and Legend and choose the hierarchy level you want
Hi! I think this quite unrelated but I tried using your formula but there is an error with how the data is presented. I am only using a card as a visualization
Using the DAX formula, total sum last year is blank if only one year is selected. But when consecutive years are selected, it returns a value. It also doesn't return a value if two non-consecutive years are selected.
Formula I used
Quantity last Year = CALCULATE([Total Water Consumption],DATEADD('Water Consumption'[DATE],-1,YEAR))
Note that we use a monthly data, hence the dates are, 01/01/2021, 01/02/2021,...