Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
This should be very easy, but I did not manage to get solution.
I have 3 columns of data: Name , Amount, Date
I would like to have a pivot at the end with week over week comparison, i.e. like in below matrix
------- week 21 | WoW | week 22 | WoW | week23
Jack 100 20% 120 -50% 60
John 10 20% 12 -50% 6
Go to Solution.
I am not sure how your data model looks like, but please check the below picture and the attached pbix file.
I tried to create a sample pbix file.
I suggest having a dim-calendar table that contains week information, like the attached.
I hope this sample can help to get your own solution for your own data model.
Amount total: =
SUM( Data[Amount] )
current wk vs prior wk: =
VAR _currentwkamount = [Amount total:]
VAR _currentwkenddate =
MAX ( 'Calendar'[End of Week] )
VAR _priorwkenddate = _currentwkenddate - 7
VAR _priorwkamount =
FILTER ( ALL ( 'Calendar' ), 'Calendar'[End of Week] = _priorwkenddate )
HASONEVALUE ( 'Calendar'[WK-Year] ),
DIVIDE ( _currentwkamount - _priorwkamount, _priorwkamount )
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.
View solution in original post
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.