Forum Discussion

bye4now's avatar
bye4now
Regular Visitor
6 years ago
Solved

adding a fiscal month/year column

Good morning newbie here! I have a data file, that contains daily records of transactions, I want to insert a column and lookup the date from lets say Column A, and return our filscal year. Then ru...
  • bye4now's avatar
    bye4now
    6 years ago

    Let me try that one out, I also  found a DAX function - its quite long, but I will see which one works.

     

    Thanks

  • bye4now's avatar
    bye4now
    Regular Visitor
    6 years ago

    Let me try that one out, I also  found a DAX function - its quite long, but I will see which one works.

     

    Thanks

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      6 years ago

      bye4now 

      what's the logic of calculating the column D? 21 means the week number? when does your fiscal year starts? you'd better provide more detailed info to get a proper solution.