Power BI
C-CL Excel to DAX Translation
C-CL Excel to DAX Translation Source link
Power BI
Power BI
Did you know external (Guest) users can connect to your Semantic Model using Excel? – FourMoo | Fabric
Yes, you read that right, it is possible where you have shared Power BI semantic model with an external (guest user in Entra ID) they can now connect to the semantic model using Excel. This […]
Power BI
D Excel to DAX Translation
This is part of a series of posts on Excel to DAX translation. The main article is here. DATE DATE DATEDIF DATEDIFF DATEVALUE DATEVALUE DAVERAGE AVERAGEX(FILTER(…)…) or CALCULATE(AVERAGE(…),…) DAY DAY DAYS DATEDIFF(…,…,DAY) or ([Date1] […]
Power BI
F-G Excel to DAX Translation
F-G Excel to DAX Translation Source link
Power BI
H Excel to DAX Translation
H Excel to DAX Translation Source link
Power BI
I-IM Excel to DAX Translation
This is part of a series of posts on Excel to DAX translation. The main article is here. IF IF IFERROR IFERROR IFNA N/A IFS IF(… && …),…,…) IMABS SQRT(POWER(IMREAL,2)+POWER(IMAGINARY,2)) IMAGINARY IMAGINARY IMARGUMENT ATAN(IMAGINARY […]
Power BI
L-M Excel to DAX Translation
L-M Excel to DAX Translation Source link
Power BI
P-Q Excel to DAX Translation
P-Q Excel to DAX Translation Source link
Power BI
N-O Excel to DAX Translation
N-O Excel to DAX Translation Source link
Power BI
R Excel to DAX Translation
R Excel to DAX Translation Source link