Forum Discussion
Helper ITotal Budgets for Next Month
Resident RockstarI can't understand what is happening here, I tried formatting [Req.dlv.dt] and [date] to date format but it did not work. Then I did this:
Column = DATE(YEAR(Orders[Req.dlv.dt]);MONTH([Req.dlv.dt]);DAY(Orders[Req.dlv.dt]))and join between [date] and [Column], and then it works.
No idea why this happens. Possibly go into Power Query and do the date format conversion in there
Helper IAnyhow, It is working now. Thank you very much😊
- PreetiSahu321
HI sturlaws ,
I need one more help. Similarly, I have another list as Sales which is having all the Bill Date(Data type as Date and Time) and Total Product (Data type as the Whole number). As per my requirement, I want to show the total product sales for next month. As you said previously, To get the total product sales for next month, I put the below formula which is not working for me:
Next Month Sales = CALCULATE(SUM(Sales[TotalProduct]), PARALLELPERIOD(Sales[BillDate],1,MONTH))Also, you can see my below-attached Sales report:
Please suggest me what I have to do?
- sturlaws
1. Create a date table
2. format BillDate to datatype Date
3. Connect date table and sales table on 'date'[date] 1:* 'Sales'[BillDate], just like you did for orders.
I reckon you have the sales and orders tables in the same model, it is most likely sufficient with 1 common date table
- PreetiSahu321
Hi sturlaws ,
I did the same what you have told those points. I have created one Date table, Changed the Bill date to Date format and also joined the 'Sales'[BillDate] to 'date'[date]. But still, it is showing me the same value.
Anything I have to do else?
- PreetiSahu321
Thank you😊