Power Bi M Query Adapt Small Code / Min - Max Date from other query
Budget: €12 – €18 EUR
Hello,
attached find the m code for a rolling calendar. Here the start date is hard coded and the end date is today().
What I need is the start date to be the min date of my transaction query and the end date the max of my transaction table.
My transaction table is called:
Bondaten
The column for date is called:
Datum
This is German date format dd.mm.yyyy (if it makes any difference)
The finished product should be the code in .txt file so I can copy it to the advanced editor of my query editor get all the columns that are present in this code just with different start and end dates.
!!!IMPORTANT: start your application with "Calendar"
Thank you.
attached find the m code for a rolling calendar. Here the start date is hard coded and the end date is today().
What I need is the start date to be the min date of my transaction query and the end date the max of my transaction table.
My transaction table is called:
Bondaten
The column for date is called:
Datum
This is German date format dd.mm.yyyy (if it makes any difference)
The finished product should be the code in .txt file so I can copy it to the advanced editor of my query editor get all the columns that are present in this code just with different start and end dates.
!!!IMPORTANT: start your application with "Calendar"
Thank you.