Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello , I got the problem with filter data such as above on screen.
I would like receive simple result. I wants show last date from table.
when I use measure with specific day (Date(year,month,day) everything works fine , but I use lastdate or max formula . I get wrong results
general I in my case I would like receive table with sum (TEST measure ) in latest day in table
sorry for quality of images
Solved! Go to Solution.
Hi @adii ,
You can update the formula of your measure [TEST] as below, then you can get the expected result...
TEST =
VAR last_day =
MAXX ( ALL ( 'LNG' ), 'LNG'[Date_ID] )
RETURN
CALCULATE (
SUMX ( 'LNG', [Cap [m3]] tys] * 1000 ),
FILTER ( 'LNG', 'LNG'[Date_ID] = last_day )
)
or
TEST =
VAR last_day =
CALCULATE ( LASTDATE ( 'LNG'[Date] ), ALL ( 'LNG' ) )
RETURN
CALCULATE (
SUMX ( 'LNG', [Cap [m3]] tys] * 1000 ),
FILTER ( 'LNG', 'LNG'[Date_ID] = last_day )
)
Best Regards
Hi @adii ,
You can update the formula of your measure [TEST] as below, then you can get the expected result...
TEST =
VAR last_day =
MAXX ( ALL ( 'LNG' ), 'LNG'[Date_ID] )
RETURN
CALCULATE (
SUMX ( 'LNG', [Cap [m3]] tys] * 1000 ),
FILTER ( 'LNG', 'LNG'[Date_ID] = last_day )
)
or
TEST =
VAR last_day =
CALCULATE ( LASTDATE ( 'LNG'[Date] ), ALL ( 'LNG' ) )
RETURN
CALCULATE (
SUMX ( 'LNG', [Cap [m3]] tys] * 1000 ),
FILTER ( 'LNG', 'LNG'[Date_ID] = last_day )
)
Best Regards
thanks you
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
27 |
User | Count |
---|---|
99 | |
91 | |
51 | |
49 | |
45 |