Forum Discussion

tkavitha911's avatar
tkavitha911
Helper III
1 year ago

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...
urgent help needed
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi tkavitha911,

 

I am following up to see if you had a chance to review my previous response and provide the requested information. This will enable us to assist you further.

 

Regards,

Vinay Pabbu

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

  • tkavitha911's avatar
    tkavitha911
    Helper III
    1 year ago

    Need to fixpending containers and Total containers pls help 
    im providing the sample data and out put both 

     

    MarketDateMax eta date No of containers arrivedCapacityClearence days No of containers deliverdNo of containers pending to deliverTotal containers 
    India 11-11-202411-11-20242353518 
    India 12-11-202412-11-2024245353742
    India 13-11-2024  5353237
    India 14-11-2024  5352732
    India 15-11-2024  5352227
    India 16-11-2024  5351722
    India 17-11-2024  5351217
    India 18-11-2024  535712
    India 19-11-2024  53527
    India 20-11-202420-11-2024353505
    India 21-11-202421-11-2024 535-50
    India 22-11-202422-11-20245535-50
    India 23-11-202423-11-2024 535-10-5
    India 24-11-202424-11-2024 535-15-10

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi tkavitha911,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Regards,
    Vinay Pabbu

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi tkavitha911,


      I just wanted to follow up on your thread. If the issue is resolved, it would be great if you could mark the solution so other community members facing similar issues can benefit too.
      If not, don’t hesitate to reach out, we’re happy to keep working with you on this.

       

      Regards,

      Vinay Pabbu