Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a date dimension DimDatei n my model
I want to create a new table (MonthEndTable) which will have DateKey and FullDate linked to the DimDate
So
DimDate
DateKey FullDate Monthname Weekname .....
And
MonthEndTable
DateKey FullDate(EOM)
The FullDate(EOM) should only contain end of month date
E.g.
if my Datedimension has got dates for 2018
Jan, Feb.... Dec etc., (all dates)
then MonthEndTable should have only end of month date e.g.
MonthEndTable
DateKey FullDate(EOM)
22 31/01/2018
24 28/02/2018
44 31/03/2018
55 ... and so on...
Do we have a Dax Formula which can be used here?
Solved! Go to Solution.
Hi @Sachy123
Try creating a new table:
MonthEndTable = FILTER ( SELECTCOLUMNS ( DimDate, "DateKey", DimDate[DateKey], "FullDate(EOM)", DimDate[FullDate] ), [FullDate] = EOMONTH ( [FullDate], 0 ) )
Hi @Sachy123
Try creating a new table:
MonthEndTable = FILTER ( SELECTCOLUMNS ( DimDate, "DateKey", DimDate[DateKey], "FullDate(EOM)", DimDate[FullDate] ), [FullDate] = EOMONTH ( [FullDate], 0 ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |