The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a column created that should return a date. But for some reason, it is returning the date with 2 different types of dates. When I filter appears 2 filter options with the same date. The problem is, I have a related calendar db, and it's working only for one of the date types. I'll try to explain more:
for example below, I filtered 1 date and it pops up 2 options.
(The date format is "dd/mm/yyy")
For all the columns that impact this final column, I put the same data type and also the same format (shortdate).
A_Entrega = if(factDevices[G_DataEntregaKA] <> BLANK(), factDevices[G_DataEntregaKA],
LOOKUPVALUE(factRentOrders[Data inicial], factRentOrders[Ordem de locação],factDevices[Ordem de locação]))
User | Count |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
13 | |
13 | |
8 | |
8 |