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.

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

        Hi,

        Will this calculated column formula work?

        Column = if(or(Data[Week End Date]=BLANK(),CALCULATE(COUNTROWS(Data),FILTER(Data,Data[Account Number]=EARLIER(Data[Account Number])&&Data[New Account Flag]="Y"&&Data[Date]>=EARLIER(Data[Date])-6&&Data[Date]<=EARLIER(Data[Date])))=BLANK()),BLANK(),"Y")

        Hope this helps.