Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
My report is connected to a online dataset, shared with my account. Therefore, I cannot add any colum, or import another table for example.
However, I need to change or create a new colum replacing dates + times by dates only. Example: 13/06/2018 16:20 must now be 13/06/2018.
Do you think this might be done with a new measure with some FORMAT or DATE function? Couldn't find the solution...
Best regards
Solved! Go to Solution.
Hi Green_Boby,
Yes, a measure can be used as value in a chart but can't be used as X-axis . To achieve your requirement, you should create a calculate column in the original PBIX file.
Calculate Column = FORMAT(Table1[DateTime2Date], "yyyy/MM/dd")
Regards,
Jimmy Tao
Hi Green_Boby,
Create a measure using DAX formula as below:
Measure = FORMAT(MAX(Table1[DateTime2Date]), "yyyy/MM/dd")
Regards,
Jimmy Tao
Hello,
Thank you for your message. I tried to use your formula, but when I cannot select STD_DATES_MODIFIED (dates only) as a X axis on a graph, when I could for STD_DATES (date+time).
Regards
Hi Green_Boby,
Yes, a measure can be used as value in a chart but can't be used as X-axis . To achieve your requirement, you should create a calculate column in the original PBIX file.
Calculate Column = FORMAT(Table1[DateTime2Date], "yyyy/MM/dd")
Regards,
Jimmy Tao
All right, I will see if I can do so in my file.
Thank you very much V-Yuta-Msft!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |