How to show monthly data and not the sum?

[Anonymous]

Hello everyone, 

I am trying to show in a graph the monthly values, but PowerBI sadly sums up the values instead of showing the value for each month. 

The DAX is as following: 

EBIT LTM = Calculate(sum(Facts[Value]), AdjustmentLevel[AdjustmentLevelName] = "IFRS Konzernabschluss", AccountStructure[AccountLevel1] = "Kennzahlen IFRS", AccountStructure[AccountLevel2] = "Kennzahlen zur Ertragslage", AccountStructure[AccountLevel3]= "LTM EBIT", DataLevel[DataLevelName]="IST", Period[Day.1], Period[Year]=YEAR(TODAY()))

Has anyone an idea to overcome the problem? Maybe don't use sum in the beginning? 

Kind regards 

Nick 

[v-yadongf-msft · Accepted solution]

Hi @Anonymous ,

Did you create a new column?

If it is like this, please specify the current month. For example:

CALCULATE(SUM(Fact[Value]),Filter(Period, MONTH(Period[Date_complete]) = EARLIER(MONTH(Period[Date_complete])))

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Power BI always groups the data, You need to add a key column(Not Summarized)  to the visual if do not want data to be grouped.

You can add index coulmn in power query and use that in visual

Power Query- Index Column: https://youtu.be/NS4esnCDqVw

[Anonymous]

Can't I use the data as its unique ID? 

EBIT LTM = Calculate(sum(Facts[Value]), AdjustmentLevel[AdjustmentLevelName] = "IFRS Konzernabschluss", AccountStructure[AccountLevel1] = "Kennzahlen IFRS", AccountStructure[AccountLevel2] = "Kennzahlen zur Ertragslage", AccountStructure[AccountLevel3]= "LTM EBIT", DataLevel[DataLevelName]="IST", DATESINPERIOD(Period[Date_complete], MAX(Period[Date_complete]),-12,MONTH))

[Anonymous]

Is there no easier possibility to just show the value of each month and not the sum of all previous ones?