Forum Discussion

veer's avatar
veer
Frequent Visitor
8 years ago
Solved

How to Assign Month Number Dynamically

Assign Month Number Dynamically   Example = feb=1   mar=2 april=3 . . . dec=11 current month jan is =12   Last 12 month data show  Moving AvG Prob            cureent month is jan =12 ...
Need Help
Show and Tell
Tips and Tricks
  • zoloturu's avatar
    zoloturu
    8 years ago

    veer,

     

    Please create calculated column in your table with formula below:

     

     

    DynamicMonth = IF(MOD(MONTH(Table1[CreatedDate]) - MONTH(TODAY())+12,12)=0,12,MOD(MONTH(Table1[CreatedDate]) - MONTH(TODAY())+12,12))

    Dynamic month in DAX

     

    Where Table1 = your table name,

    [CreatedDate] = your date field name.

     

    Let me know if I understood you correct.

veer's avatar
veer
Frequent Visitor
8 years ago

zoloturucurrent month is -Jan  ..so i want current month number is 12 

current, jan  12,
        _current - 1, 11,
        _current - 2, 10,
        _current - 3, 9,
        _current - 4, 8,
        _current - 5, 7,
        _current - 6, 6,
        _current - 7, 5,
        _current - 8, 4,
        _current - 9, 3,
        _current - 10, 2,
        _current - 11, 1,

this type logic i want ..in dax  

zoloturu's avatar
zoloturu
Memorable Member
8 years ago

veer,

 

Please create calculated column in your table with formula below:

 

 

DynamicMonth = IF(MOD(MONTH(Table1[CreatedDate]) - MONTH(TODAY())+12,12)=0,12,MOD(MONTH(Table1[CreatedDate]) - MONTH(TODAY())+12,12))

Dynamic month in DAX

 

Where Table1 = your table name,

[CreatedDate] = your date field name.

 

Let me know if I understood you correct.

  • veer's avatar
    veer
    Frequent Visitor
    8 years ago

    zoloturuThanks:manhappy: