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!
Im trying to create a comparison between last 2-3 weeks of sales that can be filtered per salesperson. I managed to create a table with the information of just last week, but i would like to get the table or the matrix to update automatically so i dont have to update it manually every meeting. And if possible using a color green/red to mark whenever its going up or down in sells per week vs last week.
My guess is that it would be something using today() - x. Im just very new and i dont know the full structure.
It would be something like this:
week x | week y | week z | |
Account1 | $ | $ | $ |
Account2 | $ | $ | $ |
Account3 | $ | $ | $ |
Thanks in advance!
Solved! Go to Solution.
In this scenario, I think you can add a flag column to tag Current Week and Last Week.
IsWithin2Weeks = IF ( YEAR ( Table[Date] ) = YEAR ( TODAY () ) && WEEKNUM ( Table[Date], 2 ) >= WEEKNUM ( TODAY (), 2 )-1, 1, 0 )
Then put this column into Visual Level, make it "is 1".
Regards,
In this scenario, I think you can add a flag column to tag Current Week and Last Week.
IsWithin2Weeks = IF ( YEAR ( Table[Date] ) = YEAR ( TODAY () ) && WEEKNUM ( Table[Date], 2 ) >= WEEKNUM ( TODAY (), 2 )-1, 1, 0 )
Then put this column into Visual Level, make it "is 1".
Regards,
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |