This is a very good series. Looking forward for the next episodes. How about including the theme of Power BI performance analysis and measures for improving performance.
For time intelligence, I used to think that you needed to mark your date table as the Date Table. I don't believe this is the case anymore... working with a client they have DimDate and Date. Date was marked as the date table, but the time intelligence was referencing the DimDate. The relationship to the fact table were also with DimDate. So... I wonder if this was ever the case, or whether it changed at some point? Interesting though...
When using a Date dimension table, if you make the relationship between the Date table and the fact table on a "date" data type column you don't need to mark your date table as a date table. But if for example your relationship is based on an integer date key column (eg : 20191112) you will need to mark as a date table for Time Intelligence to work.
This is such a high quality series. Amazing job!
Please share more such videos, particularly on DAX. The entire series was just awesome.
Great videos and so helpful for interview preparation, satisfactory explanation.
great stuff. I have a terrible time explaining to others what I do in Power BI and R.
This is a very good series. Looking forward for the next episodes. How about including the theme of Power BI performance analysis and measures for improving performance.
Great video.Expecting more from these series
awesome content love you both and respect pls make some info on Apps , content packs , workspace, row level security ,
For time intelligence, I used to think that you needed to mark your date table as the Date Table. I don't believe this is the case anymore... working with a client they have DimDate and Date. Date was marked as the date table, but the time intelligence was referencing the DimDate. The relationship to the fact table were also with DimDate. So... I wonder if this was ever the case, or whether it changed at some point? Interesting though...
When using a Date dimension table, if you make the relationship between the Date table and the fact table on a "date" data type column you don't need to mark your date table as a date table. But if for example your relationship is based on an integer date key column (eg : 20191112) you will need to mark as a date table for Time Intelligence to work.
Thanks for the work , i appreciate
Please add this confusing question, which is better from performance perspective; Slicer or Filter pane?
Very nice stuff..Ways to migrate MS Excel legacy reports into Power BI desktop ?
In the minute they said something about calulation and filter, what tge differnce between that