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 All,
I am preparing a sales report where I want to show accounts which moved from one stage to another in the previous week.
Week | Stage | Account Name | Previous Week |
10/16/2020 | Proposal Submitted | ABC | - |
10/16/2020 | Discovery | XYZ | - |
10/23/2020 | Contract Negotication | ABC | Proposal Submitted |
10/23/2020 | Discovery | XYZ | Discovery |
10/30/2020 | Won | ABC | Contract Negotication |
10/30/2020 | Proposal Submitted | XYZ | Discovery |
I want to calculate the Previous week column using DAX. Any help is appreciated. If I need to create any helper columns to identify previous week also, I can do.
Thanks,
Bhuvaraghan
Solved! Go to Solution.
@Bhuvaraghan , Try a new column like
maxx(filter(table, [Week] = earlier([Week])-7 && [Account ] = earlier([Account ])),[Stage])
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
Hi @Bhuvaraghan ,
You can also create a column like so:
Column =
CALCULATE (
MAX ( 'Table'[Stage] ),
FILTER (
'Table',
'Table'[Account Name] = EARLIER ( 'Table'[Account Name] )
&& 'Table'[Week]
= EARLIER ( 'Table'[Week] ) - 7
)
)
It works the same as what @amitchandak provided.
Best regards
Icey
If this post helps,then consider Accepting it as the solution to help other members find it faster.
Thanks a lot, worked like a charm 🙂
@Bhuvaraghan , Try a new column like
maxx(filter(table, [Week] = earlier([Week])-7 && [Account ] = earlier([Account ])),[Stage])
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
Thanks a lot for your help 🙂
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |