Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a large PowerBI Build - 50 tables, all related by a DateDimension and a Site Key.
Now I have a piece of data I need to add, but it's a bit unusual. It goes by Day of Week/# for the month - ex: 1st Monday in the month, 2nd Monday in the Month, so on.
I wrote equations into the date dimension to automatically categorize each date as such.. the problem is, it presents cardinality issues to relate it to the DateDimension in this manner:
Anyone have any advice - links they can share/anything to get around this issue?
This is a manually kept file and the only thing I can think of is to .. write the #s down for every day of the year? That's not feasible..
TYIA!
Solved! Go to Solution.
@amitchandak @CNENFRNL
Ok I have added columns for month and year.
Could someone please explain how I make that into a date?
I tried: lookupvalue(DateDimension[Date],DateDimension[Month],NewTable[Month],DateDimension[Year], NewTable[Year],DateDimension[DayInstance],NewTable[DayInstance])
and it returned blank..
@kressb , My approach would be to convert these Mondays to dates
Do you have month and year there in that table, I can suggest how to get the date
@amitchandak @CNENFRNL
Ok I have added columns for month and year.
Could someone please explain how I make that into a date?
I tried: lookupvalue(DateDimension[Date],DateDimension[Month],NewTable[Month],DateDimension[Year], NewTable[Year],DateDimension[DayInstance],NewTable[DayInstance])
and it returned blank..
@amitchandak I have month and year in the DateDimension; I don't have it in the NewTable.
I can add it if needed.
To convert wierd "Day of Week/# for the month" into normal date, it's more than needed but necessary for data model in your scenario.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |