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.
Hello,
Is there any way to create a calendar table in Power BI that would create a table for Just end of month dates so I could relate that table to budget and transaction tables?
I have two tables:
GLSummary- which contains actual Dates of the transactions
Budget - Which only contains Year and Period
I want to create an automatic date table that would do this:
Calendar = Claendar(EOM(MIN(GLSummaryDate), EOM(MAX(GLSummaryDate)
I know the above formula is not correct and thats what I need help with. I ultimately want a Date table that looks like this from the Minimum and Maximium Dates in the GLSummary table
Solved! Go to Solution.
aaah ok
this worked:
Calendar = FILTER (
CALENDAR ( MIN ( '00-GLSummary'[TRXDATE] ), MAX ( '00-GLSummary'[TRXDATE] ) ),
[Date] = EOMONTH ( [Date], 0 )
)
This does NOT work in Power BI. I think the DAX engine is broken
EVALUATE
FILTER (
CALENDAR ( MIN ( '00-GLSummary'[TRXDATE] ), MAX ( '00-GLSummary'[TRXDATE] ) ),
[Date] = EOMONTH ( [Date], 0 )
)
aaah ok
this worked:
Calendar = FILTER (
CALENDAR ( MIN ( '00-GLSummary'[TRXDATE] ), MAX ( '00-GLSummary'[TRXDATE] ) ),
[Date] = EOMONTH ( [Date], 0 )
)
excellent
Genious!!!
Hi @lcasey,
I am very glad to hear you have resolved your issue, please mark the right reply as answer. So other people will find the solution easily.
Best Regards,
Angelia
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |