Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I been trying to create a small table that shows a comparison between the last 3-4 weeks of sales between different accounts, and if possible add something like colors to show which ones went down/up.
My guess is that it would be something like Today() - x days, im just not there yet to create it myself. Is there any formula that i could use that does this already?
heres an example:
week x | week y | week z | |
Account1 | $ | $ | $ |
Account2 | $ | $ | $ |
Account3 | $ | $ | $ |
Any help would be apreciated.
Solved! Go to Solution.
Hi @Lsvzz,
Can you share a sample in TEXT mode please? The .pbix file would be great.
In this scenario, we need a date table.
Calendar = ADDCOLUMNS ( CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2017, 12, 31 ) ), "Weeknum", WEEKNUM ( [Date], 2 ) )
The relationship will be established through date. This week could be [Weeknum] = weeknum(today()). Last 1 week could be [weekNum] = weeknum(today()) -1. Etc.
Best Regards!
Dale
Hi @Lsvzz,
Can you share a sample in TEXT mode please? The .pbix file would be great.
In this scenario, we need a date table.
Calendar = ADDCOLUMNS ( CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2017, 12, 31 ) ), "Weeknum", WEEKNUM ( [Date], 2 ) )
The relationship will be established through date. This week could be [Weeknum] = weeknum(today()). Last 1 week could be [weekNum] = weeknum(today()) -1. Etc.
Best Regards!
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |