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.