Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!