single measure select multiple value shows in one graph
how to show three different values in one graph Redution buckts Ex Rate New Materials scrap values 0.7 0.17 0.45 0.7 0.27 0.35 0.7 0.17 0.45 Valueof Month Values Dec 2020 120 -> starting inventory Jan 121 feb 111 March 121 --> end inventory Graph should like below any idea . thanks in advance
How to remove Scientific Notation
In my table data looks like Scientific Notation.please find the screen shot. i have used below measure for the graph Total Month = IF(SELECTEDVALUE('Order Table Total'[Sno])="6.Total Month Variation",CALCULATE(SUM('Master Data Base'[Value]),ALLSELECTED('Order Table Total'[Sno])), SUM('Master Data Base'[Value])) how to trun off scientif notation in my report . i am trying to Format i am getting Error. Looking for support.the calendar it is not start with January, how to make work
Date1 = VAR MinYear = YEAR ( MIN('Date'[Date] )) VAR MaxYear = YEAR ( MAX('Date'[Date] )) RETURN ADDCOLUMNS ( FILTER ( CALENDARAUTO( ), AND ( YEAR ( [Date] ) >= MinYear, YEAR ( [Date] ) <= MaxYear ) ), "Calendar Year", YEAR ( [Date] ), "Month Name", FORMAT ( [Date], "mmmm" ), "Month Number", MONTH ( [Date] ) )
SUMX does not calculate at pivot aggregate level?
Hi everyone, I am using the following formula, and I would like to calculate the ABS ERROR between the actuals and the forecast. However, as you can see the it is not calculating at the pivot level. Shouldn't SUMX calculate the result at the aggregation provided in the Matrix? Why is not working? Thanks a lot, Riccardo
