Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
I have a very special problem. I created a macro in Excel that works. The latter is used to know the date of entry of information and that the cell is fixed. I wanted to put on macro on Excel but in a Teams group. Unfortunately, this macro does not work because it is not VBA language but DAX on Teams! Therefore, I would like to know if someone can make a macro in DAX allowing to have the date and time of entry of the information
This is the macro:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim j, iSct As Range
Set iSct = Intersect(Target, Range("A:A"))
If iSct Is Nothing Then Exit Sub
Application.EnableEvents = False
For Each j In iSct.Cells
If IsEmpty(j) Then
j.Offset(0, 3) = ""
Else
j.Offset(0, 3) = Format(Now, "mm/dd/yy hh:mm:ss")
End If
Next
Application.EnableEvents = True
End Sub
As you can see I would like the date and time entered in column A to appear in column C.
Thanks for your help
Solved! Go to Solution.
@Elie_HUCHET , we can not create macro in DAX, we can create new column in Power Query or DAX as per need
example
New column = Format(Now() , "mm/dd/yy hh:mm:ss")
@Elie_HUCHET , we can not create macro in DAX, we can create new column in Power Query or DAX as per need
example
New column = Format(Now() , "mm/dd/yy hh:mm:ss")
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
21 | |
11 | |
10 | |
10 | |
8 |