Colectables by date reporting

Question

I'm having a trouble with my visualization on powerbi desktop,&nbsp;I created a dashboard on customer debts, with the aim of monitoring customer debts, and I created metrics to organize debts into columns 0-30 days | 30-60 days | 60-120 days|&nbsp;When I generate the table view, the line does not respect the order of the columns and simply adds up all the values&nbsp;formulas below:&nbsp;&nbsp;Difference Days =VAR DataAtual = MAX('LU DATA'[Data])RETURNCALCULATE(DATEDIFF( MAX('TBL Divida Clientes'[DataVencimento]),DataAtual, DAY), CROSSFILTER('LU Data'[Data],'TBL Divida Clientes'[DataRegisto],none))&nbsp;01 - 30 Days =if([Difference Days]&gt;=01 &amp;&amp; [Difference Days]&lt;=30, [Dívida Pendente Moeda Original], blank())&nbsp;It was supposed to show like this:&nbsp;&nbsp;How it's right now:&nbsp; &nbsp;&nbsp;&nbsp;I can only see it organized when I add the document data to the line, but this is unfeasible as there are clients with +100 documents:&nbsp;&nbsp;&nbsp;&nbsp;I aprecciate if anyone can help me, thanks 🙂

lbendlin · Answer

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided. Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

anonymous · Answer

Hi&nbsp;LucasValiante77&nbsp;
&nbsp;
What is the DAX code for [Dívida Pendente Moeda Original]?
01 - 30 Days =
if([Difference Days]&gt;=01 &amp;&amp; [Difference Days]&lt;=30, [Dívida Pendente Moeda Original], blank())
Please provide sample data that fully covers your question and describe the efforts you have already made in this table visual.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
&nbsp;
Best Regards,Jarvis TangIf this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;

Forum Discussion

Related content

Dates Since last report

Subscription report date format wrong

Date Slicer - automatic update to latest Date in Online Reports

Publish Report

ALTERNATIVE DATE TIME site for powerbi report