Forum Discussion

SHAKEDALROY's avatar
SHAKEDALROY
Helper I
5 years ago

Creating a Measure

Hi,   I made a calculationg in SQL.. and i need to convert it to a measure in Power BI. In my SQL i have 3 tables (FactParkingViolation,DimIssuer,DimIssuingAgency), when i added the the tables to ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

SHAKEDALROY , You have create 1 - Many retion between dimesions and fact

DimIssuingAgency - FactParkingViolation, DimIssuer -FactParkingViolation , Also join FactParkingViolation with date table having year on IssueDate (Date[Date])

 

Then You can add +0 in the measure you are creating to have left join

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.