Forum Discussion

sochoa's avatar
sochoa
Frequent Visitor
2 years ago
Solved

Grafica con fecha correcta

Hello,

I would like to see each year with the current amount in the figures below. I already calculated them in the table above, but if I would like to show it in a grafic I can not do it propperly. 

in the example on the left you can see the "years" in the X , but the amount are not the same as I calculated before, but if I grafic with the correct amount, I can not see the years in the X section.
I would like to see the "years" in the botton of each colums. The "years" or the periods are actuallizing constantly. I need this kind of data. 

Please let me know how I should do it 

 

Currently you can see the data. Please let me know if you could address the issue.

I add the picture in order to let you know how I would like to see it.

https://drive.google.com/file/d/1EYXzvkg9c4TxCkXwY5igZDO0XK5OtUsI/view?usp=sharing

 

Spoiler
Spoiler
 

 

Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi sochoa ,

     

    Based on your description, the year seems to be customized by you ( based on the date of the day going forward).


    You can create a custom year table and then use the following MEASURE formula.

    Measure_ =
SWITCH (
    MAX ( 'Table'[Year] ),
    2024, [SALES Current YEAR],
    2023, [SALES Current YEAR - 1],
    2022, [SALES Current YEAR - 2]
)

     

    Best Regards,
    Adamk Kong

     

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

     

     

     

  • sochoa's avatar
    sochoa
    2 years ago

    Hello Adamk, your advice was helpful


    I just have one more question, what would happend next year ,(in 2025) , should I adjust the mesure every year? or could I make something to fix it? 

    Best Regards, 

     

    Sebastian Ochoa 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi sochoa ,

     

    Based on your description, the year seems to be customized by you ( based on the date of the day going forward).


    You can create a custom year table and then use the following MEASURE formula.

    Measure_ =
SWITCH (
    MAX ( 'Table'[Year] ),
    2024, [SALES Current YEAR],
    2023, [SALES Current YEAR - 1],
    2022, [SALES Current YEAR - 2]
)

     

    Best Regards,
    Adamk Kong

     

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

     

     

     

  • sochoa's avatar
    sochoa
    Frequent Visitor
    2 years ago

    Hello Adamk, your advice was helpful


    I just have one more question, what would happend next year ,(in 2025) , should I adjust the mesure every year? or could I make something to fix it? 

    Best Regards, 

     

    Sebastian Ochoa