Good afternoon,
I am new to Power Bi and I am not very fluent yet.
At the time I developed an "aging" to know the age of the receivables on customers but in an excel format. Right now, I would like to repeat the same in Power Bi.
To do so, I would like to know if it is possible to create a field in Power Bi that is the reference date. For example the 31st of March and that certain columns vary based on that date that should be able to be changed according to the user's needs.
Maybe it is a bit of a mess.
In my case, the solution on Excel was based on several formulas that said if an invoice was charged or not to a certain date based on a cell that marked it as my pivot date and all the excel and the results varied depending on that date.
That is to say, for example, I put in a cell the date March 31 that would be my pivot date. And I created columns that said if the invoices were charged or not at that date. For example, let's say we are on July 1st, but I want to know what I was owed on March 31st. So an invoice collected on April 1, would come out as not collected, but if I move the pivot date to April 2, that same invoice would come out as collected. To be able to do this, I need to establish a pivot date and put formulas referring to that pivot date.
In my IT department they tell me that this is not possible, or at least they don't know how to do it.
Does anyone know if this is possible?
Thank you very much in advance.
