Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

11 Week Look Ahead Dynamic Calculation

Hello!   I am stuck and I am really hoping that someone can help me write the DAX for the column to get the right results. Or advise on how to do this. I have a Scheduled Start Date column for when...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you! Ok I am very green in Power BI and completely self taught. What is a summary table? I was able to successfully create the first 2 columns as you listed above the Weekday and Weeknum columns. I went to add a new table and when I got to this portion: ( 'Table' ), [Date]

it gave me an error. I was trying to load my Scheduled Start Date table in that spot but it gave me a syntax error. It is loading 'Scheduled Start Date'.Date so I am thinking I am doing something wrong but it is making me select .Date. Hopefully that makes sense. 

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

HelloAnonymous 

 

Because I don't know what your requirements are used for, so I just created a table.

You need to create table by new table button.

Reference:

SUMMARIZE function (DAX) - DAX | Microsoft Docs

Can you share your formula and error screenshots in the report? If you can describe in detail how your needs are presented in the report visual, I can help you more specifically.

 

Best Regards,
Community Support Team _ Janey