Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guy
I start to make my first doc , I get field from my data base as date
it look like this
9357120
9524160
9943200
10218240
10530720
10581120
10782720
10794240
10920960
10955520
it is date or date and time
with qlik i had a script like this
date(makedate(1988,1,1)+(IVDATE/(60*24))) AS DOCDATE
how do i convert in power BI
thanks
gidon
Solved! Go to Solution.
Well, I *believe* the equivalent formula in Power BI would be:
DOCDATE = DATE(1988,1,1) + [IVDATE]/(60*24) * 1.
Well, I *believe* the equivalent formula in Power BI would be:
DOCDATE = DATE(1988,1,1) + [IVDATE]/(60*24) * 1.
thank you very much
gidon
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |