Forum Discussion

Jmccoy's avatar
Jmccoy
Helper II
5 years ago
Solved

Time Intelligence Help

I am refering to the article below to calculate a table to be used for time intelligence.  Phil Seamark on DAX I have been able to recreate a few of the options I needed following the same patter...
Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    5 years ago

    Jmccoy make this change in your DAX expression for last 2 and 3 months logic

    instead of TODAY change it to

EOMONTH(Today,-1)

     

     

     

     

  • AlB's avatar
    AlB
    5 years ago

    Hi Jmccoy 

    Something like this?

    //Last Month 
ADDCOLUMNS (
    GENERATE (
        SELECTCOLUMNS ( { "Last Month" }, "Period", [Value] ),
        GENERATESERIES (
            EDATE ( DATE ( ThisYear, ThisMonth, 1 ), -1 ),
            DATE ( ThisYear, ThisMonth, 1 ) - 1
        )
    ),
    "Axis Date", [Value] 
)

    and similar for the others

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

AlB's avatar
AlB
Community Champion
5 years ago

Hi Jmccoy 

Something like this?

//Last Month 
ADDCOLUMNS (
    GENERATE (
        SELECTCOLUMNS ( { "Last Month" }, "Period", [Value] ),
        GENERATESERIES (
            EDATE ( DATE ( ThisYear, ThisMonth, 1 ), -1 ),
            DATE ( ThisYear, ThisMonth, 1 ) - 1
        )
    ),
    "Axis Date", [Value] 
)

and similar for the others

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

  • Jmccoy's avatar
    Jmccoy
    Helper II
    5 years ago

    I am still having issues getting this week and last week. Please help!!