Re: Dax error

Janewhite · ‎11-03-2022

This SQL Script please how can this be written in DAX

SELECT
(TO_CHAR(DATE_TRUNC('month', CONVERT_TIMEZONE('UTC', 'Europe/London', CAST(store_open AS TIMESTAMP_NTZ))), 'YYYY-MM')) AS "scheduled_month",

( COUNT(DISTINCT case

when Year_sales != No Sales'
or (case
when Store_Close = 1 then true
when Store_Close = 0 then false
end) = true
then Store_ID
else null
end ) ) * 1.0
/ nullif(( COUNT(*) ),0)

KNP · ‎11-03-2022

Really hard to help with the info given.

Would need to see the complete SQL, your current data model/relationships, and preferably, some sample data from the relevant tables.

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.