cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kisti_ps New Member
New Member

DAX

I have data like this :

DateUnit Sales
Jan-9763
Feb-9726
Mar-9720
Apr-9741
May-9783
Jun-9740
Jul-9788
Aug-9795
Sep-9774
Oct-9767
Nov-9752
Dec-9710
Jan-9835
Feb-9875
Mar-9832
Apr-9846
May-9837

 

If I want to calculate YTD 1997, it's not Full Year in 1997 but until May 1997 like YTD 1998 until May 1998. So do I if I want to calculate YTD 1996, it's until May 1996. Thanks for the solution

1 REPLY 1
ibarrau Established Member
Established Member

Re: DAX

Hi. First of all you need to understand that any time intelligence calculations work with a Date Table. Date table are necesary so the engine can run specific time calculations la year to date. Once you hace this data model prepared you can create a measure like this:

 
Measure YTD =
CALCULATE (
    [Measure Unit Sales],
    DATESYTD (
        'DateTable'[Date],
        "04/30"
    )
)
 
On this case the YTD will start on May 1st.
Regards,

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 218 members 2,016 guests
Please welcome our newest community members: