Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
75 | |
68 | |
41 | |
35 |
User | Count |
---|---|
107 | |
56 | |
52 | |
48 | |
40 |