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 all,
i have created a visualization in PBI Desktop that looks like this table below
The Number of occurences is coming from one table
The number of units shipped is coming from another
column in common for the two tables is the Date
i need to reproduced exactly the same overving but in a table "behind the scenes". any suggestions?
@alevandenes , You need share some table details for exact formula,
But these videos can help. refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Hi Amit,
Thank you for your reply.
Number of occurences: DISTINCTCOUNT(issue number) from Issues table
Number of Units shipped: SUM(units shipped) from Sales date
i have a dimensional Date table that links Creation Date of Issue to Shipment Date
@alevandenes , then you can create a measures from both tables and analyze it with common dimensions like date?
yes, i am doing that but i need to use output of these measures as input for another measure. so i thought of creating a stating table in the background. but i dont know which formulas to use to do that
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |