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

5 Replies

  • lukiz84's avatar
    lukiz84
    Memorable Member
    3 years ago

    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?

     

     

     

     

  • 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