Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm starting with PowerBI, so my question is probably obvious ...
I have data that represent customers searches :
date | term | number of results | ....
I group my data by term with a slicer on time, no problem.
I have one row per term and the number of times customers make this search.
Now, I want to add a column to display the last (most recent) value of "number of results".
The idea is : During the last 2 month, I have 12345 searches on the keyword "mouse". It can be relevant for a marketer to know approximately how many products ours search engine actualy show for this search.
I try severals thing ... but I can not.
I want something like to get value associate with the LASTNONBLANK date ... but I didn't find.
Some help would be appreciate !
Regards,
Solved! Go to Solution.
Hi @p-caron
Try this Measure if it works for you.
CALCULATE( LASTNONBLANK( 'Table'[Text], 'Table'[Text] ), LASTDATE( 'Table'[Date] ) )
Hi @p-caron
Try this Measure if it works for you.
CALCULATE( LASTNONBLANK( 'Table'[Text], 'Table'[Text] ), LASTDATE( 'Table'[Date] ) )
Thank you very much !
This is exactly what I want.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |