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

Hi Anonymous 

 

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

  • 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.