Friday, July 10, 2020

Power BI

POWER BI

1-: How can you assign a number (1-4 or 5) to each week of the month In dax?  

Week_month = 1 + WEEKNUM ( 'Table'[Date] )-WEEKNUM( STARTOFMONTH ('Table'[Date]))
By -

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SQL

How to use the  GROUP BY  clause or  ROW_NUMBER()  function to find duplicate values in SQL Server.  The query for finding the duplicate va...