Forum Discussion

Worlock's avatar
Worlock
New Member
6 years ago

Merge date into graph with correct dates

Hi all,   Im totally new to Power BI, and just playing arround with it. My use case is this: Whenever I fill up my car at the gas station, I note the amound of KM's I drove. Together with the lite...
Need Help
Worlock's avatar
Worlock
New Member
6 years ago

BTW, the date are in a different format.

 

ConsumptionDate = DD-M-YYYY

WindspeedDate = YYYMMDD

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    You can convert both to dates like this if power bi has not detected these as dates

     

    ConsumptionDate = DD-M-YYYY

    Date = date(right([ConsumptionDate],4),mid([ConsumptionDate],4,1),left([ConsumptionDate],2)

    in case there are to MM in between

    Date = date(right([ConsumptionDate],4),mid([ConsumptionDate],4,2),left([ConsumptionDate],2)

    WindspeedDate = YYYMMDD

    Date = date(left([ConsumptionDate],3),mid([ConsumptionDate],4,2),right([ConsumptionDate],2)

    or

    Date = date(Mid([ConsumptionDate],1,2),mid([ConsumptionDate],5,2),right([ConsumptionDate],2)

    in case there 4 YYYY

    Date = date(left([ConsumptionDate],4),mid([ConsumptionDate],5,2),right([ConsumptionDate],2)

     

    Join both of them with common date dim