Forum Discussion
pstanek
Post Patron
Post PatronOne parameter ,two slicers
Hi I have table with columns date( Datetime or date or months) , price(number) , company(string). I would like to create visual with 4 columns Company name, Total price period 1, Total price per...
OwenAuger
Super User
Super UserYou can use the method presented in this article:
https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/
It relies on having a Date table and a 'Previous Date' table (with an inactive relationship).
Have a look at that and please post back if you need further assistance applying it in your model.
Regards,
Owen