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.
Please help in converting below SQL query to DAX-
Select A.*,(Currentmonth-1) As PreviousMonth from ( select max([SeqID])AS Currentmonth
from [dbo].[CT]
where [Month]=1)A
I think you can directly write SQL query while pulling data into PowerBI from SQL. Go to Get Data>Select SQL Server Database> Select Import Data Connectivity mode> Expand Advanced Options and then write SQL Query. Do not forget to set time out time.
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |