Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
User | Count |
---|---|
98 | |
90 | |
84 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |