Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello Everyone
Please help!
I am starting my first PBI project.
But there are some problems.🤔😑
My customers want TABLES with
1. Sales by Week over Week and difference % comparison too /week comparing last week/
2. This year Week sales comparing Last year week sales and difference % as well. /2019.01st week comparing 2018.01st week.../
Are there any methods to show like that? Or it isnt possible to show like that in Power BI?🤔😐🙄😃
🤔😶😑
Hi @Anonymous
Because there is no sample data I will try to describe the approach I would take.
Here I"m assuming your client wants everything in Table "Matrix"
Sales Week Over Week :
Make New Column of Week Num
WeekNum = WEEKNUM(Table-Date)
Now use this column with revenue/sales data to show sales by week.
Please make sure to change Value -Sales to sum.
2. Calculate Same period last year
Regards,
Gaurav Raj Singh
If you need more help,
Contact with me on linkedIN :https://www.linkedin.com/in/gauravrajsingh/
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
16 | |
10 | |
8 | |
8 | |
7 |