Forum Discussion
Solved
create a table from master table using DAX
I have the Master table by name "h1_daily"as follows Insertion Number Month Date WEEK NO SHIFT GROSS OPERATING TIME ITEM CODE Status MACHINE NET OPERATING TIME AVAILABLE TIME EXPECTE...
Hi Vish_korg ,
You can achieve your desired output by using the 'Unpivot Other Columns' function in Power Query. I’ve attached an example pbix file for your reference.
Best regards,
Hi Vish_korg ,
You can achieve your desired output by using the 'Unpivot Other Columns' function in Power Query. I’ve attached an example pbix file for your reference.
Best regards,
I have done this by unpivoting and well as in power query.But I require this in DAX if possible.In power query I find it difficult for to link data to main table to get required output in dashboard.