Forum Discussion

PBI_AMS's avatar
PBI_AMS
Icon for Helper I rankHelper I
2 years ago
Solved

Add a date stamp to new data on scheduled refresh

I'm ultimately planning to build a snapshot table using Power Automate, but first I need to engineer a date stamp.  I'm querying a CRM database where users are toggling a field to indicate a change i...
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    2 years ago

    DAX has built in functions for that. Read about EXCEPT and INTERSECT.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

DAX has built in functions for that. Read about EXCEPT and INTERSECT.

  • PBI_AMS's avatar
    PBI_AMS
    Icon for Helper I rankHelper I
    2 years ago

    This sounds pretty promising! Thank you for bringing to my attention. 

  • PBI_AMS's avatar
    PBI_AMS
    Icon for Helper I rankHelper I
    2 years ago

    Confirmed that this was exactly what I needed!