Forum Discussion

jackperry61's avatar
jackperry61
Frequent Visitor
1 year ago

Date changing when uploading to service

Good afternoon,   I have a report which I am uploading to the PowerBI service from my desktop app. In the desktop app there is a list of contracts called PBI_RentalContractLines. Each Contract has ...
Need Help
KNP's avatar
KNP
Icon for Super User rankSuper User
1 year ago

Can you share a screenshot of your model/relationships?

It seems more likely that the dates being defined are not broad enough to cover the data and likely a result of the service wanting to do everything in UTC (which is incredibly frustrating). Especially with IR.

My thinking is, if it is a UTC issue and it is affecting the dates enough to kick it back to the last day of the previous year, and your model doesn't cater for it, it could be getting a default 1899 date.

 

jackperry61's avatar
jackperry61
Frequent Visitor
1 year ago

Good morning, 

 

Screenshot of the relationships below. I should note the FC_RentalBillingStartDate and FC_RentalBillingEndDate that are converted into the LineRentalDate in the DAX formula are calculated using the below two DAX formulas (basically just to fill in any blanks, if there are any in the original data).

 

The bit that I'm really struggling to understand is why it is only doing this for the "Ancillary Revenue" data rather than the "Rental Revenue", even though it is all pulling from the same table.

 

FC_RentalBillingStartDate =
IF (
    ISBLANK(PBI_RentalContractLine[RentalBillingStartDate]),
    IF (
        ISBLANK(LOOKUPVALUE(PBI_RentalContractHeader[ShipmentDate], PBI_RentalContractHeader[No], PBI_RentalContractLine[DocumentNo])),
        PBI_RentalContractLine[RequestedDeliverydate],
        LOOKUPVALUE(PBI_RentalContractHeader[ShipmentDate], PBI_RentalContractHeader[No], PBI_RentalContractLine[DocumentNo])
    ),
    PBI_RentalContractLine[RentalBillingStartDate]
)
 
 
FC_RentalBillingEndDate = IF(
PBI_RentalContractLine[FC_RentalBillingStartDate]>PBI_RentalContractLine[RentalBillingEndDate],
PBI_RentalContractLine[FC_RentalBillingStartDate],
IF(ISBLANK(PBI_RentalContractLine[RentalBillingEndDate]),PBI_RentalContractLine[RequestedDeliveryDate],PBI_RentalContractLine[RentalBillingEndDate]))