Calculated Measure Not showing up

[CQueen]

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

[v-jianpeng-msft]

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

Get Power BI Previous Week Values Using DAX & Power Query | Master Data Skills + AI (enterprisedna.c...

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.