Forum Discussion

Collins26390's avatar
Collins26390
Frequent Visitor
2 years ago

Days Since Measure on Map Visualisation

Hello,   I have created a Power BI report to log the frequency and location of visits carried out by the gas engineers I work with. I have added a map visualisation to help illustrate this and...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

Collins26390 , to me it seem like a column not meausre .

 

Create a column in the table RealTimeData

Days Since Last Visit = DATEDIFF('RealTimeData'[Date of Last Visit],TODAY(),DAY)

 

or measure

Days Since Last Visit =

Averagex( 'RealTimeData',  DATEDIFF('RealTimeData'[Date of Last Visit],TODAY(),DAY)

 

or

 

Days Since Last Visit =

Sumx( 'RealTimeData',  DATEDIFF('RealTimeData'[Date of Last Visit],TODAY(),DAY)