Forum Discussion

DataJuggler's avatar
DataJuggler
New Member
3 years ago

Weird power Bi dax issue

Dear experts,

 

as you can see below , when i plot something in excel, it give me right output, but when i convert the same table to line graph or bargraph, value of the month is shifted backward, as you can see August value is 17,365 but in graphs its showing against september

 

Note: below is the dax i am using

 

InboundEOM =
VAR __END_DATE = MAXX(ALLSELECTED('InboundDates(Disconnected)M'), 'InboundDates(Disconnected)M'[End of Month])
VAR __START_DATE = EOMONTH(__END_DATE, -6)
RETURN
CALCULATE (
DISTINCTCOUNT ( RECEIPT_CONTAINER[CONTAINER_ID] ),
FILTER (
RECEIPT_CONTAINER,
RECEIPT_CONTAINER[End of Month] >= __START_DATE && RECEIPT_CONTAINER[End of Month] <= __END_DATE
)
)

looks like when this measure is plotted in graph, its showing weird result

1 Reply