Forum Discussion

Gattinomio's avatar
Gattinomio
Icon for Helper I rankHelper I
3 years ago
Solved

Fiscal Year and Month Calculation

Hello,   I am new to Power BI and currently struggling with some of the calculations I need.   I have created the two following identical calculations to get my fiscal year and month.   Fiscal...
Need Help
  • BiNavPete's avatar
    BiNavPete
    3 years ago

    Hi Gattinomio 

    I think you formatted the amounts from the ribbon rather than via DAX. So whilst they display correctly the underlying data is still the date, hence multiples.

    Try working the calculated columns in the attached PBIX into your model, using the DAX FORMAT command. ShortNoSeq is a column to assist the sort order.
    PBIX Here.

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!

    Pete
    Linked In: https://www.linkedin.com/in/pete-smith-955b73181




BiNavPete's avatar
BiNavPete
Icon for Resolver III rankResolver III
3 years ago

Hi Gattinomio 

I think you formatted the amounts from the ribbon rather than via DAX. So whilst they display correctly the underlying data is still the date, hence multiples.

Try working the calculated columns in the attached PBIX into your model, using the DAX FORMAT command. ShortNoSeq is a column to assist the sort order.
PBIX Here.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!

Pete
Linked In: https://www.linkedin.com/in/pete-smith-955b73181