Some days ago I been asked by a BI developer about how to set format of SSAS Tabular date column to dd/mm/yyyy in SSDT(Sql Server Data Tools). If you…
Author: Ali Sharifi
How to manage ambiguous relationship in Power BI
One issue you may have faced during modeling in Power BI and SSAS tabular is getting error on creating relationship between 2 tables and when this new relationship makes a…
Year to Year Growth by Fiscal Weeks
Although calculating year to year growth simply can be done by using DAX formulas such as SamePeriodLastYear() or DateAdd(), but for some business that tracking their metrics on weekly base…