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.
Thanks for helping me out on this. I'm one of the people making the transition from excel.
I'm trying to get the daily consumption of a facility by input types.
E.g each product we make is stored in a table with corresponsing dates
1/1/20 - 100
1/2/20 - 100
Input types
this data is standard for the month
a-50%
b-50%
I want to create a new table combining these 2 to get an output something like this,
1/1/20 a 50
1/1/20 b 50
1/2/20 a 50
1/2/20 b 50
Is there a way to do it?
Solved! Go to Solution.
@lokeswer - OK, in DAX you would do a CROSSJOIN I believe, like this:
@lokeswer - OK, in DAX you would do a CROSSJOIN I believe, like this:
Probably. But, is that actually how your data looks? Exactly what does your data look like?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Also, are you trying to do this during import or are you trying to do this after import?
Inputs | BOM% |
Shred | 0.16 |
RS | 0.13 |
P10 | 0 |
WC1 | 0.14 |
WC2 | 0.13 |
WC3 | 0.17 |
RAR | 0.25 |
Hams | 0.02 |
Date | Usage |
Thursday, April 30, 2020 | 297,379 |
Friday, May 1, 2020 | 375,637 |
Saturday, May 2, 2020 | 375,637 |
Sunday, May 3, 2020 | - |
Monday, May 4, 2020 | 375,637 |
Tuesday, May 5, 2020 | 375,637 |
Wednesday, May 6, 2020 | 375,637 |
Thursday, May 7, 2020 | 297,379 |
Thanks @Greg_Deckler for chiming in,
This is how the dataset look like.
I'm trying to do this during import - (obviously i cleaned up the usage data)
@lokeswer - OK, in DAX you would do a CROSSJOIN I believe, like this:
@lokeswer - OK, in DAX you would do a CROSSJOIN I believe, like this:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
85 | |
69 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |