Forum Discussion

heygowtam's avatar
heygowtam
Helper II
3 years ago
Solved

Dax for Auto Change

I am working on the Dashboard which is Season Based  for Example - Financial Year 2021 - Season 20, the Finacial year 2022 = Season 21,  Financial Year is from July to June  Dax Below -  ...
Need Help
  • v-yinliw-msft's avatar
    v-yinliw-msft
    3 years ago

    Hi heygowtam ,

     

    You can use the method that Anonymous mentioned.

    like this:

    Add a column:

    All Seasons =
ADDCOLUMNS (
    CALENDAR ( DATE ( 2019, 1, 1 ), TODAY () ),
    "Financial Year",
        IF ( MONTH ( [Date] ) >= 7, YEAR ( [Date] ) + 1, YEAR ( [Date] ) )
)

     

    If your data refreshed, the DAX code will follow it to refresh.

     

    Hope this helps you.

     

    Best Regards,

    Community Support Team _Yinliw

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

heygowtam's avatar
heygowtam
Helper II
3 years ago

Anonymous 
its not working that way 

v-yinliw-msft's avatar
v-yinliw-msft
Community Support
3 years ago

Hi heygowtam ,

 

You can use the method that Anonymous mentioned.

like this:

Add a column:

All Seasons =
ADDCOLUMNS (
    CALENDAR ( DATE ( 2019, 1, 1 ), TODAY () ),
    "Financial Year",
        IF ( MONTH ( [Date] ) >= 7, YEAR ( [Date] ) + 1, YEAR ( [Date] ) )
)

 

If your data refreshed, the DAX code will follow it to refresh.

 

Hope this helps you.

 

Best Regards,

Community Support Team _Yinliw

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