Forum Discussion

Resalat's avatar
Resalat
New Member
4 years ago

Dynamic Table based on Search

Dear all users I am new to PowerBi and taking an online course. However, my management wants something, and I am unsure I can solve it. Furthermore, I am having trouble finding a way to solve it, ei...
DAX
dynamic table
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
4 years ago

Hi Resalat ,

 

 

Item

ELESTA300001

  

Date

MRN

Issue

Present Stock

01-Jan-22

 

 

10

02-Jan-22

 

 

10

03-Jan-22

 

 

10

04-Jan-22

 

 

10

05-Jan-22

 

 

10

06-Jan-22

 

 

10

07-Jan-22

 

 

10

08-Jan-22

 

 

10

09-Jan-22

 

 

10

10-Jan-22

100

 

110

11-Jan-22

 

 

110

12-Jan-22

 

 

110

13-Jan-22

 

 

110

14-Jan-22

 

 

110

15-Jan-22

 

60

50

16-Jan-22

 

 

50

17-Jan-22

 

 

50

18-Jan-22

 

 

50

 

Is this the dynamic table you want to create? 

 

 

Item

ELESTA300001

    

Date

MRN

Issue

Present Stock

01-Jan-22

 

 

10

 

Where did this part come from? What format is the original table in?

 

 

Best Regards,

Icey