Forum Discussion

JamesBurke's avatar
JamesBurke
Helper III
2 years ago
Solved

Rank x

Hi ,    Solved: Count Top 1 Rank per day - Microsoft Fabric Community   I'm intrested in doing something similar to this but for Months however my datasets are split into tables and do not have t...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi JamesBurke 

     

    If you want to create another table with data from these 3 tables, CROSSJOIN could be a good choice.

    Here I create a set of sample for your reference:

    Then add a table:

    Table = 
	FILTER(
		CROSSJOIN(
			SELECTCOLUMNS(
				'Device',
				'Device'[Values2],
				"DeviceID", 'Device'[ Dim device ID],
				"DateID", 'Device'[Dim date id]
			),
			'DeviceUsage',
			'Date'
		),
		[DeviceID] = 'DeviceUsage'[ Dim device ID] && [DateID] = 'Date'[Dim date id]
	)

    The result is as follow:

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JamesBurke 

 

If you want to create another table with data from these 3 tables, CROSSJOIN could be a good choice.

Here I create a set of sample for your reference:

Then add a table:

Table = 
	FILTER(
		CROSSJOIN(
			SELECTCOLUMNS(
				'Device',
				'Device'[Values2],
				"DeviceID", 'Device'[ Dim device ID],
				"DateID", 'Device'[Dim date id]
			),
			'DeviceUsage',
			'Date'
		),
		[DeviceID] = 'DeviceUsage'[ Dim device ID] && [DateID] = 'Date'[Dim date id]
	)

The result is as follow:

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.