I am trying to get a Prior Week measure to calculate from a Current Week measure. Other measures based off of the Current Week measure work but the measures based off of the Prior Week do not. Can anyone help me with this? I think it is an issue with the Prior week output value type but cant seem to figure it out.
Current Week measure Calc: This works in all Current Week measures except Prior Week
Prior Week measure Calc and Outputs:
Do you know why or if there is a formula that call pull prior week from a long list of weeks with duplicates?
Thanks
Connor
Hi, @CQueen
You should add columns from your date table to the matrix or table for the measure to calculate. Measures rely on the current context calculations. According to the information in your picture, you are only putting measures in the matrix or table, so the display is empty.
Are you able to provide sample data that doesn't contain privacy in part based on your DAX expressions? Describe the output you are looking forward to.
In addition, you can refer to the following articles:
DAX for CURRENT WEEK VALUE and PREVIOUS WEEK VALUE - Microsoft Fabric Community
Week Is Not So Weak: WTD, Last WTD, and This Week ... - Microsoft Fabric Community
Rolling Weeks - Microsoft Fabric Community
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Power BI Monthly Update - June 2024
Check out the June 2024 Power BI update to learn about new features.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
