Forum Discussion
Inventory Ledger
Qilk Expression :
=if(Trans_Date < Date(FDATE,'DD-MM-YYYY'), 'OPENING', Date(Trans_Date, 'DD-MM-YYYY'))
In Power BI use date in between range is not coming to previous closing data in first row
Which Dax used?
1 Reply
Hi guruvammal ,
It's currently difficult to do this in the built-in table/matrix, and you can register ideas to help Power BI do it better here.
Welcome to Microsoft Fabric Ideas
Some paid custom visuals support inserting rows like this:
Insert row and manually enter data in Power BI matrix reports - Inforiver
You can also refer to this pattern to create another measure to output each new opening inventory.
Semi-additive calculations – DAX PatternsBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
