Use Measure result as column header

[F800]

Hi, I'm trying to build an access control matrix that provides IN and OUT times for each worker. I got it working by picking the Earliest badge scan into the building and the latest badge scan out of the building. The readers have direction indication so not a big deal.

My issue now is with the night shift, as the badge scan IN will happen anytime in the afternoon and the badge scan OUT next morning. The result I have right now is that the OUT time for each day is actually the shift end for the day before.

I've created a Measure that compares IF Earliest IN > Latest OUT then the otput will be Latest OUT - 1 Day

OUT_TimeC = IF(MIN(GT[IN Time])>MAX(GT[OUT Time]),MAX(GT[OUT Time])-1,MAX(GT[OUT Time]))

The data for a single user looks like this:

 

The result is correct, but still placed under the same original date in a Matrix visual. Which makes sense as the row is still tied to the calendar date regardless of the result of the Measure.

What I need is use the Measure result date as the column header of the matrix. Not sure if I'm actually thinking on the right solution but here is where I'm stuck with my basic knowledge in PowerBI and Power Query. I'm just learning DAX and have not done Calculated columns or such so far.

Thanks in advance.

[lbendlin · Accepted solution]

You cannot place measures in column headers. What you can do is use a disconnected reference table that feeds your column headers, and a new measure that calculates your ol measures depending on the reference value.

This also means that you need to know all possible measure names in advance.

[v-aatheeque]

Hi @F800 ,

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @F800 ,

If a community member’s response addressed your query, please mark it as "Accept Answer" and click "Yes" if you found it helpful.

If you have any further questions, feel free to ask.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @F800 ,

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!