Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

MAX Week data for current campaign

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
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
v-jingzhang
Community Support
3 years ago

Hi Anonymous 

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.