Forum Discussion
need help this calculated table by using dax
Could you please help me create a calculated table in Power BI using DAX? I have two tables: Calendar and Inbound_Query. The Inbound_Query table includes the following columns: Market, Supply Catego...
Hi tkavitha911,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
Vinay Pabbu
Need to fixpending containers and Total containers pls help
im providing the sample data and out put both
| Market | Date | Max eta date | No of containers arrived | Capacity | Clearence days | No of containers deliverd | No of containers pending to deliver | Total containers |
| India | 11-11-2024 | 11-11-2024 | 23 | 5 | 3 | 5 | 18 | |
| India | 12-11-2024 | 12-11-2024 | 24 | 5 | 3 | 5 | 37 | 42 |
| India | 13-11-2024 | 5 | 3 | 5 | 32 | 37 | ||
| India | 14-11-2024 | 5 | 3 | 5 | 27 | 32 | ||
| India | 15-11-2024 | 5 | 3 | 5 | 22 | 27 | ||
| India | 16-11-2024 | 5 | 3 | 5 | 17 | 22 | ||
| India | 17-11-2024 | 5 | 3 | 5 | 12 | 17 | ||
| India | 18-11-2024 | 5 | 3 | 5 | 7 | 12 | ||
| India | 19-11-2024 | 5 | 3 | 5 | 2 | 7 | ||
| India | 20-11-2024 | 20-11-2024 | 3 | 5 | 3 | 5 | 0 | 5 |
| India | 21-11-2024 | 21-11-2024 | 5 | 3 | 5 | -5 | 0 | |
| India | 22-11-2024 | 22-11-2024 | 5 | 5 | 3 | 5 | -5 | 0 |
| India | 23-11-2024 | 23-11-2024 | 5 | 3 | 5 | -10 | -5 | |
| India | 24-11-2024 | 24-11-2024 | 5 | 3 | 5 | -15 | -10 |
Hi tkavitha911,
Blank values in your input columns do affect measures, especially when doing cumulative or row-by-row logic.
Attached pbix file for your reference
Regards,
Vinay Pabbu