Forum Discussion

jxkang's avatar
jxkang
Frequent Visitor
2 years ago

Power Query Level of Detail

I am trying to create a column which tells if an account is a new account in that week.  I have an example data attached which is a daily log of an account.  In this example, the account was create...
Need Help
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Why do you want to do this in the Query Editor?  Why not as a calculated column formula using DAX?

  • jxkang's avatar
    jxkang
    Frequent Visitor
    2 years ago

    What would be the DAX formula for calculated column?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      2 years ago

      On second thoughts, i think a measure will be the best.  Sevenhills has already provided you with a measure.

      • jxkang's avatar
        jxkang
        Frequent Visitor
        2 years ago

        Is there a way to create a separate physical table (not table visual) with Weekly? 
        A Measure wouldn't work for my case.