Forum Discussion
jmstran87
7 years agoFrequent Visitor
YOY Comparison
Hi, I have seen several conversation surrounding this topic but I can't seem to find a solution that works for the data set I am working with. Although new to Power BI, the DAX experessions are e...
jmstran87
7 years agoFrequent Visitor
Anonymous
The reason that there is only a month field in my ecommerce table is because I only receive data on a monthly basis. Would creating a date field to still represent the month make a difference? I'll go ahead and try it out.
- James
jmstran87
7 years agoFrequent Visitor
Ok. That did not work. If someone can provide step by step what is needed to be done in order to generate YoY, given the tables I have, that would be great. I guess DAX isn't as easy as I thought. Note that data in the Ecom table is only provided at a Monthly level.
DimDate Table
Ecom Table