Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a strange problem that i think this community can help me with.
I using this DAX
Why do i get some values and others not?
Solved! Go to Solution.
Some of your timestamps contain fractions of seconds. Force the Tid column to drop these fractions.
Also please don't use LOOKUPVALUE for that. Use a proper function like OFFSET.
Hi @lbendlin ,thanks for the quick reply, I'll add further.
Hi @Anders_Dahl ,
The Table data is shown below:
Use the following DAX expression to create a measure
Measure = CALCULATE(MAX('Table'[Value]),OFFSET(-1,ALLSELECTED('Table'[Value]),ORDERBY('Table'[Value],ASC)))
Final output
Hi @lbendlin ,thanks for the quick reply, I'll add further.
Hi @Anders_Dahl ,
The Table data is shown below:
Use the following DAX expression to create a measure
Measure = CALCULATE(MAX('Table'[Value]),OFFSET(-1,ALLSELECTED('Table'[Value]),ORDERBY('Table'[Value],ASC)))
Final output
Some of your timestamps contain fractions of seconds. Force the Tid column to drop these fractions.
Also please don't use LOOKUPVALUE for that. Use a proper function like OFFSET.
HI @lbendlin
It would be great if you could show an example when using OFFSET.
In documents it looks like the OFFSET works best in a MEASURE. Is that correct?
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
User | Count |
---|---|
57 | |
48 | |
18 | |
16 | |
15 |
User | Count |
---|---|
116 | |
42 | |
41 | |
27 | |
21 |