Dynamic comparison values

rajaparthasarathy
rajaparthasarathy Member
in Magic ETL

Hi Team,

How to compare two dates values comparison in dynamics with examples coding

Thanks,

Raja Parthasarathy

Best Answer

  • trafalger
    trafalger Coach
    edited February 2024 Answer ✓

    Without more detail, our standard practice is in the dataflow to copy the rows of data, roll them forward a year and mark them "Prior year" and the original "Current year."

    This way on the card you can set it to "Current Month" and then use the "prior year" vs. "current year" flags to determine the difference but the card responds to the calendar.

    image.png

Answers

  • GrantStowell
    GrantStowell Admin

    Hi @rajaparthasarathy,

    Could you maybe clarify your question or provide screenshots of the issue you're trying to solve for?

  • trafalger
    trafalger Coach
    edited February 2024 Answer ✓

    Without more detail, our standard practice is in the dataflow to copy the rows of data, roll them forward a year and mark them "Prior year" and the original "Current year."

    This way on the card you can set it to "Current Month" and then use the "prior year" vs. "current year" flags to determine the difference but the card responds to the calendar.

    image.png

Categories