Forum Discussion

Philthy's avatar
Philthy
Regular Visitor
8 years ago

April fools?

Ok - is someone at Microsoft having a giigle at my expense?   I work in health and have just received the new quarterly data for patients beginning April 1, 2018.  I've imported it into my warehous...
Philthy's avatar
Philthy
Regular Visitor
8 years ago

Well I'm pleased it isn't just me (though I'm sorry it's affecting you guys too!).

 

My reports are currently sourced from a single master table, which combines a myriad of stuff into an easily consumed data feed, so all I've done is add an extra field to the ETL process which delivers a text-based date instead of an "actual" date.  This works fine (a bit of a pain to have to replace everywhere, but didn't take too long).  A bonus to this method is not having to follow the PowerBI date types, so I can format the date however I like (e.g. something nice and short which doesn't take up lots of space).

Rakshya's avatar
Rakshya
Frequent Visitor
8 years ago

I have wasted two days just to fix with zero outcome, whenever I try to run the dashboard for 1st April 2018, it ignores and does not bring any data. I tried replacing the value with some other future dates, it works fine but does not work for Ist April.

I am trying to filter txn_date within a table, it filters for rest dates except 01/04/2018. 

Is it because of Day light saving causing this issue? This is impacting my BAU tasks, can anyone please assist?

Regards,

Rakshya