Forum Discussion
CONVERT SQL QUERY TO DAX Measure
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 iamgesAnonymous you might need to format your result, it usually displays like that when a number is to long, what is the data type? can you show the result in a table to see the result properly
Hi,
Please see this great video of scripting a Power BI date table.
Thanks
