Forum Discussion
CONVERT SQL QUERY TO DAX Measure
Dear vanessafvg,
thanks for your answer.
yes I want to get last years values
but the resultes show with me not the same sql query resulte , also i don't have date table, how i can cearte **bleep** and what are the values must be inside table to apply your answer ,
kindly find snapshop image after applying your answer without date table , i use only my attribute called "as_of_date
"
Anonymous you have to have a continious date range to use the function, therefore you need a data table
you can use this script to create a date table
www.mattmasson.com/2014/02/creating-a-date-dimension-with-a-power-query-script/
then link the date to the date in your table
then create the measure
Dear vanessafvg,
thanks for your answer.Can You guid me how I can create date table in power bi and where I can paste Script ?
Best Regards,
Anonymous into a blank page into power query
if you read the post i posted it gives you all the details, please read it
Dear vanessafvg,
thanks alot ,
the creation of table done and make relation between date table and my Measure table , but the the resulte is wrong, please finde bellow iamges
Hi,
Please see this great video of scripting a Power BI date table.
Thanks
