Hello, i have some previous SAS experience but I am trying to learn more about power BI. My report in SAS has a lot of formulas and I am trying to figure out what is the best means of translating SAS to Power BI. Here is an example...
Curr Mo Curr Yr = IF ( Max [_ByGroup_] ('Flag Bounce Rate %'n) > 0 )
RETURN ( ( ( Sum [_ForAll_] ('# of bounces (curr mo curr yr)'n) / Sum [_ForAll_] ('# emails sent (curr mo curr yr)'n) ) * 100 ) Round 1 )
ELSE (
IF ( Max [_ByGroup_] ('Flag Open Rate %'n) > 0 )
RETURN ( ( ( Sum [_ForAll_] ('# emails opened (curr mo curr yr)'n) / Sum [_ForAll_] ('# emails sent (curr mo curr yr)'n) ) * 100 ) Round 1 )
ELSE (
IF ( Max [_ByGroup_] ('Flag Click Thru Rate %'n) > 0 )
RETURN ( ( ( Sum [_ForAll_] ('# of Clicks - Total (curr mo curr yr)'n) / Sum [_ForAll_] ('# emails sent (curr mo curr yr)'n) ) * 100 ) Round 1 )
ELSE Sum [_ByGroup_] ('Metric (curr mo curr yr)'n) ) )
Where can I go to get Power Bi translations. Like: 'ByGroup', etc.
I am even having difficulty just trying to pull Today's date (without time), everything i have been trying as one error or another.
Like Today = Date(now()) or Today = Now(year, month, day) ...etc. Cant hit the nail on the head!
Thanks
