Forum Discussion
LOD conversion to DAX
- Converted it DAXCALCULATE(SUMX(wip_pj_py_experience,wip_pj_py_experience[M_Count_Policy]),(wip_pj_py_experience[SEQ]=0),ALLSELECTED(wip_pj_py_experience[SEQ],wip_pj_py_experience[DC_SEQ_GROUP]))
Anonymous what is this expression supposed to do? You should share sample data with the expected output or explain what this function is doing? If someone never used Tableau not sure if they will understand what this formula is supposed to do.
Hi Parry2k,
I am doing a Triagular Matrix in Power BI replicating the Triangular Matix from Tableau.
Seq number
MonthYear 0 1 2 3 4 5 6........to 60
202101 Value....................................................
202102 Value....................................................
202103
202104
202105
Value is Derived by sum(M Count Policy)/
{EXCLUDE [SEQ],[Floor[SEQ]/12]:
CASE [Policy or Risk Survival:]
WHEN 'XXX' THEN SUM(IF [SEQ]=0 THEN [M Count Policy] END)
}