Forum Discussion

venug's avatar
venug
Helper II
6 years ago
Solved

DAX - multiple Month display

Hi Everyone,   I have no date column, instead of month like number 1,2,3,...12. when i select month in slicer. i want to show "Jan", "Mar", "Oct" like this. Random month selection should need.   ...
Need Help
  • venug's avatar
    venug
    6 years ago

    Anonymous 

     

    Thanks for reply, we have huge amount of data, data structure also maintained different formate. to avoid performance issues and pbix file should below 1gb we maintain data like in numerics. 

     

    can please provide DAX query on this..

    Thanks in adance..

     

    Regads

    Venu

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hello,

     

    You can  also make a new table with 2 columns

    1 Jan

    2 Feb

    3 Mar

     

    And so on and link this as a one to many to your data.

     

    Kr

     

    Maxim

  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago
    Hi venug 
     
    As Anonymous  said before,you can consider creating a new table and establishing a relationship.
    You can also consider using power query to convert connected data.
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago
Hi venug 
 
As Anonymous  said before,you can consider creating a new table and establishing a relationship.
You can also consider using power query to convert connected data.
 
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.