Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic Mapping of Transaction Dates

Hi All,   Can someone please help me to find a solution to map the transaction date using this scenario. Transaction monthly cutoff (21st date Previous month to 20th Current month.   This is what...
Need Help
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Anonymous 

Try this column

New Column = 

IF(
    DAY(review[createddatetime]) > 21 ,
    FORMAT( EOMONTH(review[createddatetime],1) , "Mmm YYYY"),
    FORMAT( review[createddatetime] , "Mmm YYYY")
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you for the reply.  The result is the same with my code.

     

     

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      5 years ago

      Anonymous 

      I did it on a sample dates table and it works, you may share a sample file to check:

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thank you Fowmy . This is what i'm looking for using a date table but could not figure out how can I add those setup in my date table. Currently, my PBI has DateTable. Could you please share the date table you are using.  Thank you in advance.

         

        my DateTable