I’ve been learning Power BI for only 2 weeks. I see great potential in this tools (thanks to enterprisedna), yet I still need to learn A LOT.
I need help getting the monthly difference of many products.
Here is the screenshot in excel: I want to change the left table into the right table.
I have tried many times in Power BI, mostly using Measures to create the new column. Here is the formula I created, but it failed:
Diff FactoryA = calculate(CALCULATETABLE(Sheet2, Sheet2[ProductName], Sheet2[FactoryA]), DATEADD(values(Sheet2[Date]), -1, MONTH))
My real case is involving almost 100 of ProductName and 8 Factory. The date consists of monthly data over 4 years. In practice, I can still handle this with excel using many sheets and vlookup.
So, my question is:
- How can I solve this with Power BI? Can I use Measure to create the new table, for the sake of saving memories?
- Which course should I watch, so I can learn faster on this topic?
- @sam.mckay I want to post more screenshot for clarity but new user can only post 1 picture…