Forum Discussion
PreetiSahu321
Helper I
Helper ITotal Budgets for Next Month
Hello Power BI Community Members, I have a Budget list which is having all the Budget Dates (Data type as Date and Time) and Budget Amount (data type as the Whole number). As per my requirement, ...
sturlaws
Resident Rockstar
Resident Rockstar1. 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
PreetiSahu321Helper I
Helper IHi 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😊