Forum Discussion

SVM9698's avatar
SVM9698
Regular Visitor
2 years ago

Time intelligence migration from Tableau to Power-BI

Hi All.   I have a little tricky scenario while migrating report from Tableau to Power-BI, where i have a input fact table with dates of present month and previous year same month with some values ...
audreygerred's avatar
audreygerred
Icon for Super User rankSuper User
2 years ago

Hello! I suggest utilizing the date reference table from SQLBI I have referenced in my blog post: http://powerbiwithme.com/2023/08/01/the-custom-date-table-edition/. For the time intelligence you can get started by utilizing the following:

Sales TY = SUM('FactTableName'[Current Year Sales])

Sales PY = CALCULATE (SUM('TableName'[Current Year Sales], SAMEPERIODLASTYEAR('DateTableName'[Date])))

For units do same as above two, but use the unit fields instead.