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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply

Help how to get a Total Substraction

Hello Community,

 

I hope you can suggest me how to get a "Total substraction" (dinamically)

I have a table where the progress is by Month like this

 

PROJECT2022 JANUARY PROGRESS2022 FEBRUARY PROGRESSN MONTH PROGRESS
A10%20%20%
B20%30%35%

 

So I'm able to get use the visualization Array Table to show that info, so I need to show the difference between the lastDate and the oldDate dinamically, so the difference has to be calculated with the substraction of progress of selected months, examples:

 

if 2022 Qtr4 selected then difference will be December progress - October

if December 2022 and December 2021 selected then the difference will be of December 2022 December 2021

 

I got to create the Measure to calculate it dinamically but I cannot add it properly to my array table 😞

JOSELUISMTZRMZ1_1-1673910306044.png

 

I need to add the measure at the left as the default total column is shown when turned on, the measure column is desired to be shown like that

 

JOSELUISMTZRMZ1_0-1673909756872.png

If I added it doesn't work, see below, I don't want the measure in Values and I don't want the Total column of progress but needed  turned on to show the measure column as desired

JOSELUISMTZRMZ1_3-1673911237295.png

 

Any suggestion? How can I get it using array table or common table?


Measure: 

Cut0ffDate_Difference =
calculate(sum(MonthlyPercent[CutOffPercent]), LASTDATE(MonthlyPercent[CutOffDate]))  -calculate(sum(MonthlyPercent[CutOffPercent]), FIRSTDATE(MonthlyPercent[CutOffDate]))

 

Thanks!!!

0 REPLIES 0

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

Top Solution Authors
Top Kudoed Authors