Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
NCLSOG
Regular Visitor

TOTALYTD Function : Cumulativ doesn't work

Hello, 

 

I get a problem with the function TOTALYTD. In the screenshot below, the datas highlighted in green are correct. 

 

TOTALYTD.jpg

 

The total per trimestre (Total1) is well displayed via this syntax : 

 

 

Total1 = SUM(APM[ID])

 

 

 

 

In the fourth column, i would like to display, a total cumulativ. Each line "Total1" has to be added to the previous one. I use this code without success. I get the same result that the ones' calculated in the column "Total1". 

 

 

 

 

 

 

VCA = 
TOTALYTD ( [Total1], APM[creationDate] )

 

 

 

 

 

 

Below the table used for the data.

 

  MCD.jpg

 

An idea ? 

 

Thx

1 ACCEPTED SOLUTION
v-heq-msft
Community Support
Community Support

Hi  @NCLSOG ,

Here are my test process

To achieve your goal, you can follow these steps:

Here are my test data:

vheqmsft_0-1702884740998.png

1.Open Transform data and split TrimeStre column and merge  Annee column and TimeStre.1 column

vheqmsft_1-1702884753549.png

vheqmsft_2-1702884760538.png

vheqmsft_3-1702884769758.png

2.Create two measures by using dax

 

Total1 = SUM('Table'[ID])
VCA = 
VAR _table = SUMMARIZE(ALL('Table'),'Table'[Merged],"_value",[Total1])
RETURN
SUMX(
    FILTER(_table,
    [Merged]<=MAX('Table'[Merged])),[_value])

 

3.Create a table and use merged column ,two measures

4.Final output

vheqmsft_4-1702884831471.png

In order for you to solve the problem faster, you can refer to the following documentation

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Best Regards,

Albert He 

 

View solution in original post

2 REPLIES 2
v-heq-msft
Community Support
Community Support

Hi  @NCLSOG ,

Here are my test process

To achieve your goal, you can follow these steps:

Here are my test data:

vheqmsft_0-1702884740998.png

1.Open Transform data and split TrimeStre column and merge  Annee column and TimeStre.1 column

vheqmsft_1-1702884753549.png

vheqmsft_2-1702884760538.png

vheqmsft_3-1702884769758.png

2.Create two measures by using dax

 

Total1 = SUM('Table'[ID])
VCA = 
VAR _table = SUMMARIZE(ALL('Table'),'Table'[Merged],"_value",[Total1])
RETURN
SUMX(
    FILTER(_table,
    [Merged]<=MAX('Table'[Merged])),[_value])

 

3.Create a table and use merged column ,two measures

4.Final output

vheqmsft_4-1702884831471.png

In order for you to solve the problem faster, you can refer to the following documentation

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Best Regards,

Albert He 

 

lbendlin
Super User
Super User

Time Intelligence functions require a calendar table that is contiguous and covering.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.