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" )

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.