Forum Discussion

trabass's avatar
trabass
Frequent Visitor
8 years ago
Solved

DAX Calculation Help - Appending and filtering records

I'm stuck figuring out the dax formula to achieve the following.   Have a table of data (Tasks) which I report off.  Been asked to take quarterly snapshots (Tasks Archive) to "lock" the values repo...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi trabass

     

    I think there is a way in QUERY Editor to get the SOURCE TABLE name.

     

    Nevertheless...since it appears that Archive Date is Blank for TASKS table... you may add this calculated column to get the source

     

    Source =
IF ( ISBLANK ( MergedTable[Archive Date] ), "Tasks", "Tasks Archive" )

trabass's avatar
trabass
Frequent Visitor
8 years ago

Hi Zubair_Muhammad

 

Thank you very much for the reply.  I didn't know about using variables in dax - learning slowly...

 

I shouldn't of included "Source" as an example column.  Unless when you do an append can you add a column that identifies which table the row of data was appended from?

 

Working on changing the formula you provided (thnks). 

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Hi trabass

     

    I think there is a way in QUERY Editor to get the SOURCE TABLE name.

     

    Nevertheless...since it appears that Archive Date is Blank for TASKS table... you may add this calculated column to get the source

     

    Source =
IF ( ISBLANK ( MergedTable[Archive Date] ), "Tasks", "Tasks Archive" )

    • trabass's avatar
      trabass
      Frequent Visitor
      8 years ago

      Zubair_Muhammad Thanks very much for your help.  Didn't think of capturing the source that way, seems to easy now.