The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Need help
I have date column which consist date & time value, this date value has value of data inserted table, data is inserted in table multipale times in a day so i have same date but time is different.
Example : time & data row inserted count.
8/2/2022 3:31:37 AM +00:00 | 71627 |
8/2/2022 3:11:46 AM +00:00 | 123 |
I want to write a dax which give me information for respective time. I have connected data through direct query mode.
Hi @Anonymous
is this a text format? What is the + 00:0071627?
Below is sample of data
customercode | customername | envtype | dataTime | prem |
123 | ABC | qa | 6/22/2022 14:53 | 16828908.55 |
123 | ABC | uat | 6/22/2022 14:53 | 256508373.1 |
123 | ABC | prod | 6/22/2022 14:53 | 266719635.1 |
@Anonymous
Thank you. would you please advise the expected output based on this sample.
we need a filter data based on latest ingestion time. need to show result as below.
data is loading multiple time in a day so we have duplicate date & data but time changed everytime so we need data to show only for latest time "prem" & "Countc".
some time "prem" & "countc", remain same for day, it may change any time if transction happens.
Time prem CountC
002 IMT prod 6/22/2022 2:53:29 PM 266719635.05 15
for more details you can call me 9923310100, or email thoratyogesh1@gmail.com
yes this is text format
@Anonymous
What is the + 00:0071627?
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |