Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi guys,
For example, Staten Island opened in Week 8 of 2021, we would compare sales of that store from Week 9 2021 onwards with Hyannis that opened in Week 17 of 2022.
I will defenitley appreciate can anyone give solution for this.
Thanks,
Srikanth
Solved! Go to Solution.
Hi,
Please check the attached file and the below.
1. create a dim-calendar table
2. create a relationship between the sales table and dim-calendar table
3. create two calculated columns in the sales table
main point is to create a calculated column = Normalized Wk number CC
Normalized Wk number CC =
RANKX (
SUMMARIZE (
FILTER ( Sales, Sales[Store] = EARLIER ( Sales[Store] ) ),
Sales[Startdate of Wk CC]
),
Sales[Startdate of Wk CC],
,
ASC
)
4. create a measure that shows sales total and put it into the visualization that uses one of the newly created calculated columns as the X-axis
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the attached file and the below.
1. create a dim-calendar table
2. create a relationship between the sales table and dim-calendar table
3. create two calculated columns in the sales table
main point is to create a calculated column = Normalized Wk number CC
Normalized Wk number CC =
RANKX (
SUMMARIZE (
FILTER ( Sales, Sales[Store] = EARLIER ( Sales[Store] ) ),
Sales[Startdate of Wk CC]
),
Sales[Startdate of Wk CC],
,
ASC
)
4. create a measure that shows sales total and put it into the visualization that uses one of the newly created calculated columns as the X-axis
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you.
it was helpful
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
83 | |
62 | |
61 | |
58 |
User | Count |
---|---|
157 | |
118 | |
103 | |
76 | |
66 |