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
Am not really sure how I would tackle this issue I have, I have thought of many ways but none of been successful.
I have a column that displays flat data that I do not want to summarize and shows a cumulative value against a 15 min time, this data is supplied by forecast so it’s always flat data image below.
Then I have created a table that displays data by a measure and a column of 15minutes window. The measure gives me the total shipments and then I apply the 15 column to breakdown the table to show the volume between these times. The tables are also unrelated.
The problem that I have got is how would I divide my measure breakdown Vs my unrelated do not summarize column? if its possible...
So how would I divide image one with image 2 to give me the difference between each time increment?
This is my measure that gives me my total shipments,
Solved! Go to Solution.
@Anonymous ,
It seems that you may just use LOOKUPVALUE.
@Anonymous ,
It seems that you may just use LOOKUPVALUE.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |