Forum Discussion

Revealer's avatar
Revealer
Frequent Visitor
3 years ago

Fiscal Year Table issue

Hi i have  entrydate column from 2019-2022 for changing to fiscal table i have used  calendar auto(03) Dax query 

column created from2007-2022 is coming.without creating separate table Fiscal year is coming correctly .

1 Reply

  • Mahesh0016's avatar
    Mahesh0016
    Super User
    3 years ago

    Revealer 

    new table = calendar(min(Table[entrydate]),max(Table[entrydate]))

     

    If this post helps, please consider accept as solution to help other members find it more quickly.