MAX Week data for current campaign

[NatashaT]

Hi All,

I am new to DAX. Does anyone know who to get the max week data for current campaign (month) in Power BI? Please advise.

Thank you,

NT

[v-jingzhang]

Hi @NatashaT 

Sorry the expected result is not clear. Do you want to get the data (total, average, or a single value?) of the max week (last week) for current campaign (month)? Or get the max data (perhaps weekly data) in a campaign (month) only? Can you provide some sample table data or examples to help explain what you want to get? How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Community Support Team _ Jing

[NatashaT]

I am sorry for lacking of descriptions. I am referring to getting help about creating new measure that gives me the latest data by campaign for ineligible, attested and remaining population for the current campaign.

For previous campaign, the latest week of the current campaign has to match with the previous campaign. Please see sample of data below.

[v-jingzhang]

Hi @NatashaT 

Thanks for the data, but what is "campaign" in the data? What is the current campaign and what is previous campaign? Do you refer to Year-Qtr as campaign?

Jing

[NatashaT]

Campaign is a product weekly report (numbers). The current campign is 2022-Q4 Week 2. But I don't have current data. I am referred to Year-Qtr-Week as camapign.

[lukiz84]

Hi

• this should be posted in the DAX or PBI Forum, has nothing to do with PowerQuery.
• What do your tables look like? How should we know from your very brief description?
• What's the question, it's not clear to me?