Forum Discussion
vincenttys
2 years agoHelper I
Measure help
Hi all, I have a data as below and column highlighted in yellow is a calculated column based on Entry Time Deviation and Exit time Deviation. I want to use this data and generate report similar to t...
datawailor
2 years agoAdvocate II
May be a little challenging to explain but ideally, you do this in power query by
- Reference the table to create a seperate table we'll use to set somethings up
- create a list of all the entry and exit time variance values (entry time variance <15, entry time variance -15 to 0, etc)
- Add a column that concatenates "% " to each entry
- Add an index to the lis
- Select the Index column created and unpivot on the other columns
- Add a column that enables you distinguish between values and %ages. Something like if left(Label,1) = "%" then "%age" else "value"
- Add another column that groups your values into Entry time deviation and Exit time deviation using a similar method as the previous step
Once the you have the table, you can close and join the field to the main table with the data and do the rest with DAX. Things like this are typically best done with Power query and am sure im missing a smnall step but you get the idea. if i have time i could buiold it out
vincenttys
2 years agoHelper I
Hi datawailor
I have a go and i think i can create a separate table but not sure how to join it back to the main table with data. Can you please assist?
Thank you